asked on
SQL server peformance issues in production
Hi All
I have Sql sever 2012. In production I am seeing slowness in database.
How do I find slow running queries.
How do we check the CPU usage.
How do I see any deadlock.
Do we have queries to check this?
Any other metrics to check?
Also we have few SSIS packages. They load lot of new data from the files. The DB size is 1.5 TB.
Thank you!!
I have Sql sever 2012. In production I am seeing slowness in database.
How do I find slow running queries.
How do we check the CPU usage.
How do I see any deadlock.
Do we have queries to check this?
Any other metrics to check?
Also we have few SSIS packages. They load lot of new data from the files. The DB size is 1.5 TB.
Thank you!!
DatabasesMicrosoft SQL ServerSSISSQL
Last Comment
Pavel Celba
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No need to reinvent the wheel.
Use Task Manager and Resource Monitor to check the overall computer functionality and bottle necks.
Scripts for SQL Server also exist - look e.g. here: https://www.brentozar.com/ and download and test all sp_Blitz.... scripts. They are perfect for people like you (and me).
Queries to check SQL Server blocking are e.g. here: https://www.mssqltips.com/sqlservertip/2927/identify-the-cause-of-sql-server-blocking/
Of course, you'll need to learn additional knowledge to understand Query Plans, SQL Profiler output etc. etc.
Use Task Manager and Resource Monitor to check the overall computer functionality and bottle necks.
Scripts for SQL Server also exist - look e.g. here: https://www.brentozar.com/ and download and test all sp_Blitz.... scripts. They are perfect for people like you (and me).
Queries to check SQL Server blocking are e.g. here: https://www.mssqltips.com/sqlservertip/2927/identify-the-cause-of-sql-server-blocking/
Of course, you'll need to learn additional knowledge to understand Query Plans, SQL Profiler output etc. etc.
But first of all check your queries performance. If the database design is poor (not normalized, lack of indexes, ...) then is highly possible that your queries will be unperformed. You can start by using SQL Server Profiler to capture the long running queries and analyze them, one by one.