Tag: dba
-
Renaming a Failover Clustering Instance of SQL Server
Can you rename the SQL virtual name in a Cluster? The answer for this in SQL Server 2005 is obviously Yes. New to SQL Server 2005 is the ability to rename a clustered instance of SQL Server without having to uninstall and reinstall it.
-
SQL Server Configuration Settings
Introduction: This article brings you the allowable configuration options in SQL Server which includes options that are new to SQL Server 2008 also. The options can be used to tune, optimize and maximize the performance of the system in variety of ways. But careful planning and examination should be done before you implement the change.…
-
Memory Management in SQL Server
Introduction: I have heard people asking me how SQL Server manages memory. The answer to this was very difficult with SQL Server earlier versions. And with SQL Server 2005 it has been simpler to explain and understand. SQL Server by default installation manages memory dynamically and has settings that it can well negotiate with the…
-
Mirrored Backups
Mirrored backup is a feature available in SQL Server 2005 Enterprise Edition and Development Edition. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations.
-
Database Management Views & Functions – SQL 2005
DMV’s are system views and its a new feature started SQL server 2005 with nearly 80 DMVs. DMV’s are system view that surface the internal counters of the database engine help present an easily comprehendible dashboard of the database engine performance that can be used to monitor the health of a server instance, diagnose problems,…