Home

i doing SQL tuning in Company databases but i don't know where to start

%3CLINGO-SUB%20id%3D%22lingo-sub-1129899%22%20slang%3D%22en-US%22%3Ei%20doing%20SQL%20tuning%20in%20Company%20databases%20but%20i%20don't%20know%20where%20to%20start%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129899%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22votecell%20post-layout--left%22%3E%3CDIV%20class%3D%22js-voting-container%20grid%20fd-column%20ai-stretch%20gs4%20fc-black-200%22%3E%3CSPAN%3Ei%20am%20doing%20SQL%20tuning%20in%20Company%20databases%20but%20i%20dont%20know%20where%20to%20start%20as%20i%20am%20new%20in%20DBA%20i%20joined%20new%20company%20where%20they%20have%20lots%20of%20databases%2C%20and%20it%20issue%20with%20databases%2C%20can%20anyone%20help%20me%20where%20to%20i%20start%20what%20should%20be%20step%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1129899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Tuning%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130373%22%20slang%3D%22en-US%22%3ERe%3A%20i%20doing%20SQL%20tuning%20in%20Company%20databases%20but%20i%20don't%20know%20where%20to%20start%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385037%22%20target%3D%22_blank%22%3E%40Ops_Biren%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20the%20steps%20provided%20here%3A%3C%2FP%3E%3CP%3E%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mssqltips.com%2Fsqlservertutorial%2F276%2Fsql-server-performance-tuning-and-monitoring-tutorial%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mssqltips.com%2Fsqlservertutorial%2F276%2Fsql-server-performance-tuning-and-monitoring-tutorial%2F%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3Eor%20here%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fwww.toptal.com%2Fsql-server%2Fhow-to-tune-microsoft-sql-server-for-performance%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.toptal.com%2Fsql-server%2Fhow-to-tune-microsoft-sql-server-for-performance%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ETo%20properly%20learn%20SQL%20tuning%20read%20all%20of%20the%20content%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fperformance%2Fmonitor-and-tune-for-performance%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fperformance%2Fmonitor-and-tune-for-performance%3Fview%3Dsql-server-ver15%3C%2FA%3E%3CBR%20%2F%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130463%22%20slang%3D%22en-US%22%3ERe%3A%20i%20doing%20SQL%20tuning%20in%20Company%20databases%20but%20i%20don't%20know%20where%20to%20start%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385037%22%20target%3D%22_blank%22%3E%40Ops_Biren%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20newer%2C%20it%E2%80%99s%20really%20difficult%20to%20start.%20But%20in%20fact%2C%20database%20tuning%20is%20not%20a%20easy%20topic%20to%20describe%20shortly.%20If%20you%20would%20like%20to%20spend%20time%20to%20dig%20in%20it%2C%20please%20have%20a%20look%20for%20those%20links%20that%20replied%20by%20previous%20expert.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EOtherwise%2C%20I%20think%20I%20can%20give%20you%20some%20tips%20to%20get%20direction%3A%3C%2FP%3E%3CP%3E1.%20Clarify%20why%20does%20the%20tuning%20need%20to%20be%20done%3A%20ex%3A%20transactions%20work%20slowly%2C%20specific%20report%20runs%20slowly%2C...etc.%3C%2FP%3E%3CP%3E2.%20Gathering%20the%20data%20via%20SQL%20profiler%20and%20assigns%20the%20target%20database%2C%20tables...%3C%2FP%3E%3CP%3E3.%20Analyzing%20the%20data%20via%20SQL%20server%20optimizing%20tool%3A%20this%20tool%20can%20show%20you%20the%20suggestions%20for%20you.%26nbsp%3B%3CBR%20%2F%3E4.%20Choose%20the%20appropriate%20suggestion%20and%20then%20turn%20the%20target%20manually%3A%20Please%20DO%20NOT%20applies%20tuning%20suggestion%20via%20optimizing%20tool%20because%20you%20cannot%20realize%20what%20to%20be%20changed.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20tips%20above%20are%20just%20give%20you%20a%20direction%20to%20start.%20Hope%20it%20is%20useful%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ops_Biren
New Contributor
i am doing SQL tuning in Company databases but i dont know where to start as i am new in DBA i joined new company where they have lots of databases, and it issue with databases, can anyone help me where to i start what should be step
2 Replies
Highlighted

@Ops_Biren 

 

As a newer, it’s really difficult to start. But in fact, database tuning is not a easy topic to describe shortly. If you would like to spend time to dig in it, please have a look for those links that replied by previous expert. 

Otherwise, I think I can give you some tips to get direction:

1. Clarify why does the tuning need to be done: ex: transactions work slowly, specific report runs slowly,...etc.

2. Gathering the data via SQL profiler and assigns the target database, tables...

3. Analyzing the data via SQL server optimizing tool: this tool can show you the suggestions for you. 
4. Choose the appropriate suggestion and then turn the target manually: Please DO NOT applies tuning suggestion via optimizing tool because you cannot realize what to be changed. 

The tips above are just give you a direction to start. Hope it is useful for you.

 

Related Conversations
SQL Migration to Azure Cloud
Gohulan in Azure Migration on
0 Replies
Windows 10 VPN and SQL with Meraki VPN
redtechguy in Windows 10 on
4 Replies
Windows 10 VPN and SQL with Meraki VPN
redtechguy in SQL Server on
0 Replies
HOW can i combine 3 columns as sub columns
Varghese97 in SharePoint Developer on
0 Replies
Excel with Sql Server connection
petyac81 in Office 365 on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies