Category: DBA
-
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,…
-
List of DMVs & DMFs available in SQL Server 2005
I’ve listed down all the DMV’s that are related to SQL server 2005
-
Backup Maintenance Plan with Cleanup task
This article provides a complete description about configuring backup using maintenance plan including cleanup task. This will be useful to junior DBA’s and also for the persons who have no voice in SQL server. This article is applicable for both SQL 2005 & SQL 2008.
-
Enable Disable Remote connections Via DOS or T-SQL
Ive seen in forums seeking to enable disable Remote connections via DOS prompt T-SQL. Ive searched google for this topic and didnt get any article on this topic, so i decided to write a procedure to change Remote connections via T-SQL so that this can be called from DOS.
-
Database Tuning Advisor – DTA
The Database Engine Tuning Advisor is a new tool in Microsoft SQL Server 2005 that enables you to tune databases for improved query processing. Database Engine Tuning Advisor examines how queries are processed in the databases you specify and then it recommends how you can improve query processing performance by modifying physical design structures such…