SQL Administration Archives - Page 15 of 16

Aug 04

Get a List of CLR’s Registered to a Database

By SQLRx Admin | SQL Administration , SQL Server , Tip of the Month

Get a list of CLR’s registered to a database. This is helpful when migrating or troubleshooting. For more information on CLR’s check out Books Online or http://msdn.microsoft.com/en-us/library/ms131089(SQL.100).aspx SELECT o.name AS ObjectName, a.name AS Assembly, o.type_desc AS ObjectType FROM sys.assembly_modules am JOIN sys.objects o ON am.object_id = o.object_id JOIN sys.assemblies a ON a.assembly_id = am.assembly_id […]

Mar 23

What’s Causing Files to Automatically Grow

By SQLRx Admin | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Every DBA has encountered a database that has a mystery statement that will unexpectedly cause either the transaction log or a table to grow out of control and fill the drive. Here is a way to find out who is running what statement that is causing the problem. Find out what statements are causing database […]

Mar 23

Attempt to Recover a Suspect Database

By SQLRx Admin | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Databases will go into suspect state for a multitude of reasons. If you find your database in SUSPECT state, check all error logs and the Windows Event Log for any related errors, and try to resolve them. This is a disaster situation! Refer to the script below for help. SQL Server Administration: You can try to […]

Dec 03

Find out How Much Data Files are Waiting with Filestats

By SQLRx Admin | SQL Administration , Tip of the Month

Disk performance is a common issue on SQL Server systems. In these situations, it is very useful to know how much SQL Server is waiting for I/O and what files are handling the most work or experiencing the poorest performance. The virtual file stats DMF provides this information and is ideal for periodic captures, e.g., […]

Oct 28

Master Database Compatibility Level

By SQLRx Admin | Miscellaneous , SQL Administration , SQL Server , Upgrade

If you performed an in place upgrade of your SQL Server, your master database may be at a lower compatibility level than all of the other system databases. This was done by conscious decision from Microsoft in an attempt to make for a smooth upgrade and ensure that existing applications can still function post upgrade. […]

Oct 07

Oct 2010 TOM: Are your backups ready for a disaster?

By SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month

Database backups are a critical part of SQL Server disaster planning. It’s also critical to know
that your backups are viable.

Sep 07

September 2010 Tip of the Month

By SQLRx Admin | Performance Tuning , SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

Performance Monitor: Monitor the performance counters SQLServer:Buffer Manager (Page reads/sec) and SQLServer:Buffer Manager (Page writes/sec) to detect poor performance. These counters measure physical IOs and not logical IOs. Heavy activity can indicate lack of database memory, a poor table implementation or can show that applications are not accessing a database correctly. Monitoring these counters will […]

Aug 06

August 2010 Tip of the Month

By SQLRx Admin | Helpful Scripts , SQL Administration , Tip of the Month

DBA’s need to know when it is safe to stop services or to do other work. It is preferable to do such things when no jobs are running to prevent job failures and data integrity issues. Check out the query below to help. SQL Server Administration: Find the next time that any enabled job will run. Run the […]

Aug 06

July 2010 Tip of the Month

By SQLRx Admin | Helpful Scripts , SQL Administration , SQL Server , Tip of the Month

If you are a DBA who needs to know how much space tables take in your databases to monitor growth trends and plan for maintenance, we have the query for you.

« Previous 1 … 13 14 15 16 Next »

Category Archives for "SQL Administration"