February 19, 2012 at 11:20 pm
Hi,
I found some of processess are taking more wait time and cpu and network. I have seen in acitivity monitor. so that what should i take action to take less wait time and all.
Please give senario to go through this any one.
February 20, 2012 at 2:39 am
What wait type?
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
February 21, 2012 at 4:27 am
In activity monitor, wait time column is taking more wait time.
February 21, 2012 at 4:27 am
In activity monitor, wait time column is taking more.
February 21, 2012 at 4:40 am
I can't even make a wild guess with this little information. If you want help, you need to give us something to work with.
What wait type?
What wait resources (if you can tell)?
Steady increase in duration?
Is the data volume growing?
Is basic maintenance being done?
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
February 22, 2012 at 2:30 am
When i execute select query, I have seen in activity monitor of processor in that column name wait time is taking more....
so i wish to know that how to troubleshoot this senario... please let me know.
February 22, 2012 at 6:45 am
What that little information, I can't offer you any help, any advice.
For general slow query troubleshooting, try these
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
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply