Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

April 2007 Blog Posts

Database Mirroring problem

Recently, I rebooted all nodes in our 4-node cluster at our disaster recovery site because I had attempted to install another SQL Server 2005 instance but the installation had indicated I needed to reboot the nodes first.  I rebooted the nodes one at a time as is best practice for a cluster.  After the reboots, I was able to successfully install the new instance. At some point after the reboot, database mirroring had entered the suspended state for most of our databases at the primary site.  This eventually caused us to run out of disk space at the primary site on the...

posted @ Friday, April 20, 2007 11:10 AM | Feedback (1) | Filed Under [ SQL Server - Database Administration ]

SQL Server 2005 Performance Dashboard Reports

If you have SQL Server 2005 service pack 2 installed on your database server, then you might want to check this out.  "The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SP2 release of SQL Server Management Studio" and "are used to monitor and resolve performance problems on your SQL Server 2005 database server." I had bookmarked the page a few weeks back since we don't have service pack 2 installed in our production environment yet.  If you've already used the reports to help resolve performance problems,...

posted @ Thursday, April 19, 2007 9:37 AM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

Database Mirroring Best Practices and Performance Considerations

We are using database mirroring to sychronize our data at the disastery recovery site for our SQL Server 2005 databases.  We are currently encountering a problem with it, so I've been googling to see if there is a fix.  While googling, I found this article.  It goes into great detail about the best practices and performance considerations for database mirroring.  I highly recommend reading it if you are using database mirroring or plan on using it. I will be creating a new weblog that describes the database mirroring problem that we are experiencing. 

posted @ Tuesday, April 17, 2007 10:59 AM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

Defragment Indexes stored procedure - new version

I have fixed some bugs in my isp_ALTER_INDEX stored procedure. Use this version instead of the old one. This stored procedure defragments indexes in SQL Server 2005. It utilizes sys.dm_db_index_physical_stats, a dynamic management function, to retrieve the fragmentation levels. If you plan to use DETAILED for @statsMode, you may want to consider running the query that builds the #FragIndex table on a database snapshot.  Kalen Delaney mentions this in the May 2006 edition of SQL Server Magazine (InstantDoc ID 49769). ------------------------------------------------------------------------------------------- -- OBJECT NAME : isp_ALTER_INDEX -- -- AUTHOR ...

posted @ Tuesday, April 17, 2007 10:29 AM | Feedback (5) | Filed Under [ SQL Server - Database Administration ]

32-bit/64-bit aliases

We don't use the default port for SQL Server for security reasons, so we usually have to explicitly tell the client how to connect to SQL Server by creating an alias on the client machine. There are many ways to create an alias on a client machine.  My favorite is via the registry as it allows me to save the values to a reg file so that we can quickly deploy them to other client machines.  Here is the location of these aliases: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo Yesterday I was configuring transactional replication between two databases on different servers.  The servers are on different...

posted @ Tuesday, April 10, 2007 10:23 AM | Feedback (0) | Filed Under [ SQL Server - General ]

Powered by:
Powered By Subtext Powered By ASP.NET