What are the specific errors appearing in the logs?

Haven't used CV, but we are using a similar product called WanSync for DR. Same sort of thing - monitors block-level activity. Rebuilding indexes would create a lot...

DBCC FREEPROCCACHE or DBCC FREESYSTEMCACHE. See BOL for details on...

Potentially you could use any port over 1024 that isn't [likely to be] used by anything else. You may be better off using a port above 49152. See...

The principal will continue to accept connections and process transactions if the mirror is down. The transactions will be queued in the principal's transaction log until communication with the...

I would just reset the NTFS permissions, either by forcing the permissions from the parent folder to flow down to the children or by altering the permissions on the files...

Are the I/Os caused by read or write activity? Is there any pattern to the occurrences? Is it definitely SQL Server & not some other rogue process (e.g....

I see that @aDatabaseName is used with RESTORE DATABASE and MOVE. Are the database name & logical name of the data file actually the same in the original database?...

I have encountered this before, but I can't remember the exact solution from memory. It's something along the lines of something locking the performance monitor counters before SQL Server...

[nitpick] Why do 'select *'? Given you are just dropping the databases, why not do 'select name' instead? Adhere to principal of 'only get what you really need'...

I thought they were already in a stored proc?

Maybe try updating your statistics and/or clearing the procedure cache.

Timothy Ford (11/28/2007)

---

Steve, isn't that kind of like hitting a nail with a sledgehammer? Or more like hitting a cute, adorable puppy with one? Even if you are...

I haven't come across any magic bullet. Everything I have read says things along the lines of 'look at performance counters x, y, z and compare with values a,...

Internally, SQL should be using the login SID, so anything referencing the sa login should reflect the new name automatically.

If you have any custom procedures or views that reference the...

There's a few things in performance monitor you can check. The most obvious is Memory: Pages/sec. If this is high, then generally more memory is required (I've seen...