January 15, 2015 at 9:36 am
Hi all,
I have SQL server 2005 installed in cluster of servers connected to storage has three major tables that contains at least 1 million records per day, it takes long days now to en-query from the database and suffering from poor performance.
how can i know what is the reason causing this delay.?
Regards
Rashed
January 20, 2015 at 10:35 pm
I would suggest going out to s place like brentozar.com and getting the sp_AskBrent stored proc and running it to see what it tells you in terms of performance issues. another thing would be to look at Wait stats on SQL Server. go to sqlskills.com and search the site for Wait stats. You could create a sql agent job to run a rtace for queries that have a duration of over 100 milliseconds. You could look at sys.dm_io_virual_file_stats and see what the read/write latency is like. As you can see, there are a number of ways to approach a broad problem like this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply