October 15, 2015 at 8:21 am
I have observed there are high values showing-up for below Server waits in our Production Report Server (SSRS,Long Process SQL Jobs)
QDS_cleanup_stale_Queries_Task_Main_Loop_sleep
Dirty_Page_Pool
can any one help on this ?
October 15, 2015 at 8:28 am
There are a lot of waits that should be high (most '%sleep%' waits for example) because they're from background processes that do some work and then go to sleep until needed again. There are a lot more that should just be ignored. Get Glenn Berry's DMV diagnostic scripts and look at his wait stats script, see which waits he ignores.
Don't just look at dm_os_wait_stats raw, you can't get much meaning out of it that way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2015 at 8:35 am
any link for Glenn Berry's DMV diagnostic scripts ?
October 15, 2015 at 8:37 am
https://www.google.com/?q=Glenn+Berry+diagnostic+scripts
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2015 at 8:46 am
No Its not exact Link. do u have exact link ? if not leave it.
October 15, 2015 at 8:52 am
I don't keep thousands of links on hand just in case someone happens to need one. I use google for that.
The exact site is the first link returned by that google search.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 1:04 pm
Gila - Could you point me to some good sites for advanced Performing Tuning scripts?
Thanks.
October 21, 2015 at 2:37 am
yes please
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply