We are a mature organization with many AlwaysOn AGs and many standalone instances.  We are trying Zerto to migrate SQL Servers to a new data center.  Of the six lower-tier...

Hi Jim,

Thank you for your reply. I have a fairly good understanding the process of switching in and switching out. I agree that partitioning would be useful for switching out...

Hey Erin,

This is great - especially the idea of baselining your configuration data!

On a related note, I log and analyze my performance counters through Performance Monitor, mainly because it's...

Thank you Lowell. This saved a lot of time!

I had the same problem. One thing I noticed was that SELECT * FROM INFORMATION_SCHEMA.TABLES executed in about 100 mS, while EXEC SP_TABLES was averaging about 3 seconds.. ...

Here are two useful reference URLs for trace flag 610:

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx

http://msdn.microsoft.com/en-us/library/dd425070%28SQL.100%29.aspx

If you can perform the move during a time that the databases are static, perhaps on the weekend, you can temporarily shut down the SQL Server Agent service(s) that are...

Here's a simple script for getting volume capacity and free space info when you have mount points. It uses a combination of WMI, ADO, and VBSCript. You...

This article will give you some insight into why shrinking is often a bad idea: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Excellent! Worked for me as well.