Home » 2014 » November

Monthly Archives: November 2014

TempDB Configuration Best Practices

1. Do not change collation of TempDB from the SQL Server instance collation. 2. Do not change the TempDB database owner from sa. 3. Do not drop the TempDB database. 4. Do not drop or revoke the guest user from the database. 5. Do not change the recovery model from SIMPLE. 6. Allow for tempdb … Continue reading

Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !

The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are facing severe issues with their environment, they can plan to test CU13 in … Continue reading

Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing severe issues with their environment, they can plan to test CU3 in test … Continue reading

Interview Questions on SQL Server Database Mirroring

1) What is default port of Database Mirroring Endpoint? Ans : 5022 2) Database Mirroring comes with which edition? Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM with trace flag 1400 3) When I configure mirroring I’m receiving the below errror, One or more of the server network addresses lacks a fully qualified … Continue reading

Script to Monitor SQL Server Database Mirroring Status

SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need to monitor Database Mirroring status continuously to ensure that everything is working fine. We can use MSDB.SYS.SP_DBMMONITORRESULTS system store procedure to monitor database mirroring. Below script … Continue reading

%d bloggers like this: