We do have a copy of the production database, which barely fits on the DEV systems. But the DEV system I'm testing on only has 16GB of memory versus...

I might be able to install and run on the inactive node of our cluster

on a sunday. I'm assuming it has to be

"installed" . Running from other...

We're on Sql 2005 Enterprise 64-bit SP4 with 128GB memory ( 88 for sql ) Active/Passive cluster, Netapp for shared storage

We had a consultant in a few years...

Thanks Kevin, we are going to test forced parameterization on our dev environment. I checked yesterday and in production 20,000 of the 40,000+ cached plans are these single-use inserts,...

Thank you very much.

Yes we really do need to upgrade to sql 2008. I'll look up forced parameterization and see if we can test it on our DEV boxes. Most sql...

There's no question how important it is to update statistics. We've seen it fix problems over and over again. So we run it for an hour nightly in our...

For us Commvault runs a log backup every 15 minutes, plus fulls on Sunday night and differentials once each weeknight plus Saturday. It's hard to imagine having to...

I'm not following as far as average disk reads/writes per second. If we mean our system is busy and doing 200 reads per second, then a less busy system...

The latest suggestion I've received is that the bulk of our problem is related to configuration of our SAN ( netapp ). Currently, average read wait per IO for...

Thanks Grant. Time to read your book on execution plans. It's sounding like no magic bullet here.

We use commonly available stored procedures to do reindexing and update stats. Stats Approach Here http://www.sqlstatistics.com/page/2/

Both do indexes first that need...

Of course, can't backup tempdb. And by "streamed" we mean normal backup method. thanks again.

I wasn't clear on whether snapmanager will backup systems databases such as master, msdb and tempdb?

Thanks again. We're not doing log shipping any longer. I'll pass this information along. This article seems to either have inaccuracies or is simply a bit...