sorry, you say your system is only rated for 400 i/o and you're pushing 800 - that doesn't really make sense, the i/o limits are down to the physical disk...

800 i/o sec isn't that much, is this the average, peak, proportion reads to writes ?  you'd only need 4 spindles to support that , well you could get away with...

flushing data out of cache will cause physical disk i/o which may degrade performance. If you can reproduce your slow and fast queries then capture and compare the query plans...

in the overall scheme of things a couple of minutes might not be too bad. You need to have baselines to perofrmance tune, otherwise you can't and you'll essentially be...

This is the problem of such tools, which largely, in my opinion, are pretty useless. I might also observe that there is little point in receiving such alerts if you...

If you rely on snapshot backups to replace log shipping you may be sadly disappointed in the event of a failure. Remember log shipping also allows you to restore to...

I do worry sometimes, ad/domain group membership is a valid and very usual method of granting users access to a sql server, to be honest the last thing you want...

the quickest way to clear tables is to truncate them, drop does not clear it removes - slight difference!!

if you're going to drop all the tables then you might just...

If you mean you overwrote a database with a backup of another my mistake and don't have a backup of the overwritten database, then I'm afraid there's nothing you can...

a NAS generally will run across ethernet as against fibre which typically a storage network would use - you have slower speed and you may fight for bandwidth as your network...

Unless this is a production system the easiest method is to switch to simple recovery, checkpoint, shrink the file, I'd usually use the dbcc shrinkfile as thus  dbcc shrinkfile(fileno)  this...

I hope we're not discussing a production system which stores sensitive/valuable data ?? Please tell me you don't work for a bank or credit card company and preferably you don't...

you really don't want to go down this path unless you want to degrade your database performance.

• Minimising database space can be better achieved by making sure all your tables have...

It could be you need to run it from the active node of the cluster rather than the virtual server - I don't have a test cluster to test on...

That's a lot of questions!!  Is it sql server that is using the cpu - you need to monitor cpu of the sqlserver process vs 100%, just in case you...