SQL server Dba for performance improvements

₹1500-12500 INR

Închis

Data postării:

circa 7 ani în urmă

₹1500-12500 INR

Plata la predare

i need help with performance tuning on sql server 2012 (extended events)

Microsoft SQL Server

ID-ul proiectului: 13405582

Despre proiect

14 propuneri

Proiect la distanță

Activ: 7 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

14 freelanceri plasează o ofertă medie de ₹10.059 INR pentru proiect

@mpalgeo

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

₹13.333 INR în 10 zile

4,9

(64 recenzii)

6,0

@arvind19821

I worked on extended events such as events, predicates, actions and targets.. knowledge including event session and analyzing output..

₹9.444 INR în 3 zile

5,0

(1 recenzie)

1,0

@MetaoriginLab

A proposal has not yet been provided

₹14.111 INR în 4 zile

0,0

(0 recenzii)

0,0

@abhijeetrana

A proposal has not yet been provided

₹6.888 INR în 5 zile

0,0

(0 recenzii)

0,0

@nijkap01

A proposal has not yet been provided

₹5.555 INR în 10 zile

0,0

(0 recenzii)

0,0

@burtonk

Good morning -- I've used extended events since they became available and use them often in my work. I need a better understanding from you regarding what we're trying to fix and how we can measure when it is now performing as expected. Once we have this I can set the milestones appropriately and get to work.

₹11.111 INR în 14 zile

0,0

(1 recenzie)

0,0

@level6llc

We are a group of developers specialized in all branches of software development. Our main goal is to satisfy 100% customers in the least time possible.

₹11.111 INR în 3 zile