March 20, 2016 at 6:07 pm
Hi All,
I have issue with my application servers ( 3 servers) that looks very busy at around 9 PM almost everyday but when I check through database server at that time it’s alright ( I am using Database Performance Monitor to monitor the query performance ), nothing stand out .
Any feedback are really appreciated
Cheers
March 20, 2016 at 6:18 pm
What is "looks very busy"? How can you measure this? What do you look at in performance monitor?
March 20, 2016 at 11:23 pm
Thanks for the reply .
So the number of very slow calls are spiking . I checked full backup but no conflict with it
Any idea what to check ?
March 21, 2016 at 6:47 am
In general, the wait statistics before and after the slow time to see what's causing things to run slow during the slow time. If you know the specific queries that are running slow, monitor them (extended events or trace) to see if it's a unique set of values that are causing things to run slow. Capture individual query waits using dynamic management views is also possible.
The key, get more metrics. You can't just guess. You have to measure and observe.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 22, 2016 at 11:53 pm
Thanks for the reply . Much appreciate it !
I am gonna run SQL Profiler tonight (the lighter method so It won’t impact sql performance) for 30 minutes between 8:45 pm – 9:15 pm.
Honestly I am not sure I will get something as expected because when I check Query performance using DPA ( Database Performance Analyzer) at 9 PM no stand out query was running …
How do I check wait statistic before and after that time?
March 23, 2016 at 2:01 am
WhiteLotus (3/22/2016)
Thanks for the reply . Much appreciate it !I am gonna run SQL Profiler tonight (the lighter method so It won’t impact sql performance) for 30 minutes between 8:45 pm – 9:15 pm.
Honestly I am not sure I will get something as expected because when I check Query performance using DPA ( Database Performance Analyzer) at 9 PM no stand out query was running …
How do I check wait statistic before and after that time?
Wait statistics - tell me where it hurts by Paul Randal.
There is a link @ the following URL to get time based analysis.
http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/"> http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply