March 1, 2011 at 12:58 pm
Hi ALL,
When I open up the Activity Monitor I see spikes in the Database I/O every 20 seconds. What does this mean ? I have SSD's on my server?
I have used the DMV's for I/O and did not find anything unusual.
Any Suggestions.
March 1, 2011 at 2:47 pm
This could happen for MANY reasons...without knowing your configuration for both SQL and your Server. Considering this occurs at 20-min intervals it sounds like something is scheduled and running....so here are a few things to think about:
1. How you have your data/log files laid out across the drives/array. Is tempdb on the same drive as your data and log files?
2. Are DB backups (including TRN log file backups running)
3. Do you have ETLs or anything else running that would be hitting the filesystem or importing large amounts of data into your DB?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply