September 20, 2010 at 1:53 am
Hi Sql sever Professionals,
If there is problem like application getting hang & is working slow. What are things I need to check to find the reason. Please suggest me the things to be checked. How to understand the problem.
The basic things I check when ever this issue has reported are follows.
CPU Utilization
Blocking
Top Physical I/O
Top CPU
Lach_ex to find internal memory issue.
Please suggest me to over come this issues in Future.
Sql server 2000,SP3, Clustering Implemented.
Rgds,
Rushi.
September 20, 2010 at 3:09 am
instead of directly blaming the sql for the slowness, you need to find
1) is application slow for all users?
2) is the network itsellf working fine?
3) If application is accessed by different location then is it slow across the location or a perticular location?
4) Which functionality with the application is slow? Is all functionality slow or any perticular functionality within application.
And further more specific to application and user accessing the application related questions...
once you have these basic detail, you can start digging your database(if required) to find the problem.
----------
Ashish
September 20, 2010 at 4:53 am
also check for Blockings and neverthless I/O.
September 20, 2010 at 1:35 pm
While all those are good suggestions, I suggest checking out Glenn Berry's blog post here, where he shares his diagnostic queries which includes one on wait stats
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2010 at 3:12 am
Hi Jacks,
Thnx a lot, the link of Glenn Berry's u have given is really useful for me. Can you please send me the same for sql server 2000 as my Production server is sql server2000.
Regards,
Rushi.
September 22, 2010 at 3:26 am
the DMVs mentioned in the link are for 2005 onwards... but similar problem you can google with sql server 2000.
I am sure you will find some queries in this website itself, else definately on some link in google
----------
Ashish
September 22, 2010 at 5:50 am
rushi.reddy (9/22/2010)
Hi Jacks,Thnx a lot, the link of Glenn Berry's u have given is really useful for me. Can you please send me the same for sql server 2000 as my Production server is sql server2000.
Regards,
Rushi.
Sorry, just assumed that you were on at least 2005 since you posted this in a SQL Server 2008 forum.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply