Any news after this weekends monitoring?

I'm easy going with either vodka or chocolate. If anybody ever needs plenty IOPS while visiting the Netherlands. Just that you know...

I agree with lynn, have your SAN admin look for iops overloading on that aggregate. Is it Netapp?

Meanwhile to see if it is truly the SAN, try restoring a back...

I'm talking about your read. Your database file is still on the SAN lun right? Or did you also try and move your mdf to local disks?

Regarding tour backup software,...

I think a key element in your reply is: vm uses local storage and your prod db uses SAN.

So how is your Server connected to your SAN? 1gbit iscsi? 10gb...

Okay let's see.

The above waitstats show you what SQL has been waiting for since it's last restart or since you last cleared the waitstats. On top of the...

I editted my post but I took a bit long because I was doing other stuff as well. meanwhile thetopic continued.

so for clarity, I'll repost 😉

sorry, misread your post. forget...

sorry, misread your post. forget about what I just wrote.

Instead:

can you look at the waitstats during your backup and post the results.

you can find a good waitstat query...

try it from the command line:

open a command prompt and run:

Cluster res

to list all resources that are still there, then run:

Cluster res "resource name"/Delete

to delete any orphaned resources.

Can't test...

I like the possibility of sps to pre validate and pre format the result set in a way that makes front end code cleaner and easier to maintain, only when...

"AWE allows SQL Server to address how much memory on Windows 2000 Enterprise Edition? "

Windows 2000 Enterprise Edition doesn't exist. I asume that what was meant was the sql version....