SQL server 2016 Query Fine Tuning (Data partitioning, ColumnStore Indexes)

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

Hi, I'm expert in sql server and I can do this job very well. Let me know the details. You'll fine me the only who has passed all three exams of sql server here Thanks Relevant Skills and Experience sql server Proposed Milestones $2222 USD - milestone

A proposal has not yet been provided

I have more than 11 years experience in SQL server

Hi, I'm a DWH/ETL/BI expert from Bulgaria (EU) with 8+ years of experience in that field. I'm proficient in wide variety of data tools Relevant Skills and Experience 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL, MSSQL, PostgreSQL, Oracle, Teradata and a few others. 3.BI-Pentaho BI, SSAS, SSRS, PowerBI, Cognos Proposed Milestones $25 USD - M1: Discuss the problems and agree on the next steps $275 USD - M2: Implement the steps from M1 Could you be more specific about the problems, because the $30 budget looks like а bad joke?

I will take a look at the query, its execution plan and see where the bottleneck is and help you improve the query. Relevant Skills and Experience Over 20 years work experience as DBA in SQL Server, Oracle and Sybase environments. I have familiar with Columnstore indexes. Proposed Milestones $40 USD - On Acceptance $71 USD - On completion

DB performance plays an important role in application performance and at the end it result in user satisfaction, on time work & growth. On behalf of my knowledge and experience I can ensure all these. Relevant Skills and Experience In 10 years of experience, from T-SQL development on SQL Server 2000 to Administering 2005, 2008 R2, 2012 and 2016 I got deep understanding of database engine. I handled OLTP and OLAP DB 3+TB in size. Proposed Milestones $5 USD - Discussion on performance issues with client $25 USD - Gather bad performing query, Indexes fragmentation, maintenance task and other info $5 USD - Discuss the report with client if any change required in indexes $25 USD - Make the changes in indexes on QA server and compare query performance ad share the report $5 USD - List big tables & depending queries and discuss which should be partitioned & how it'll benefit $25 USD - Partition the tables & index them according to queries (depends on size and No. of tables) on QA-1 $25 USD - Partition the tables & index them according to queries (depends on size and No. of tables) on QA-2 $25 USD - Partition the tables & index them according to queries (depends on size and No. of tables) on QA-3 $25 USD - Partition the tables & index them according to queries (depends on size and No. of tables) on QA-4 $25 USD - Partition the tables & index them according to queries (depends on size and No. of tables) on QA... $25 USD - Optimize the depending queries according to partition structure & indexes on QA-1 $25 USD - Optimize the depending queries according to partition structure & indexes on QA-2 $25 USD - Optimize the depending queries according to partition structure & indexes on QA-3 $25 USD - Optimize the depending queries according to partition structure & indexes on QA-4 $25 USD - collact trace of production env and replay it on UAT environment before and after changes & compare $25 USD - collact trace of production env and replay it on UAT environment before and after changes & compare $5 USD - Discuss the result with client $25 USD - Make the changes on production server with proper downtim and make sure it's successfull $25 USD - Gather server and database performance statistics and discuss $25 USD - Go through the result and and discuss $25 USD - Recomment if any change in HW/SW required $25 USD - Gather top queries taking longer and consuming more resources or tempdb and optimize-1 $25 USD - Gather top queries taking longer and consuming more resources or tempdb and optimize-2 $25 USD - Gather top queries taking longer and consuming more resources or tempdb and optimize-3 $25 USD - Gather top queries taking longer and consuming more resources or tempdb and optimize-4 $25 USD - Prepare T-SQL for index maintenance plan according the table size and structure $25 USD - Prepare T-SQL for index maintenance plan according the table size and structure and schedule it $25 USD - Gather index info and remove unused indexes on QA $25 USD - Collact production server trace and playit on UAT before & after removing the indexes $25 USD - Collact production server trace and playit on UAT before & after removing the indexes and compare $15 USD - Discuss over all database and application performance with client & continue if more tuning required Additional Services Offered $15 USD - Weekly database performance monitoring and tuning Something about the project & its workflow. No. of reports & report types. DB size & No. of big tbl

I have a good expertise on SQL Server 2016, I can help you.

Hi, I have experience in Columnstore indexes, Partitioning data and performance tuning. I have worked on large tables with billions of rows Relevant Skills and Experience I have 7 years of experience in SQL server platform Holds MCSA certification Proposed Milestones $20 USD - On Completion I am assuming it may not take more than 3 hours, we may need to review payment if it takes more