SQL Server Maintenance

Archive | SQL Server Maintenance RSS feed for this section

2 Reasons Why Failover Could Be Slow

by jmurphy on May 15, 2013 in Cloud, HADR, SQL Server Maintenance, SQL Server Performance, SQL Server Recovery

Intro Microsoft SQL Server has had Mirroring starting with version 2005, and now that SQL Server 2012 is released, there is an additional feature set called AlwaysOn (marketing info | technical info). AlwaysOn in currently an Enterprise only feature, so Standard Edition users will still need to use Mirroring. I would describe AlwaysOn this way: [...]

Read full story • Comments { 0 }

DBCC loginfo, VLFs and SQL2000 and earlier.

by jmurphy on March 24, 2011 in SQL Server Maintenance, SQL Server Presentations

I was reading Paul Randall and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL [...]

Read full story • Comments Off

About SQLWatchmen

We are a Microsoft SQL Server database administration Managed Services and consulting company which specializes in helping smaller and medium sized companies protect and manage their data, as well as tune performance. SQLWatchmen has a staff of 6 employees for round-the-clock part-time monitoring.

If your company runs on SQL Server, but you are unsure if your data is really protected, or if your Disaster Recovery plan is not complete or is untested, then give us a call at (877) SQL-Watchmen and we will help you see where you stand.