April 2007 Blog Posts
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...
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,...
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.
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 ...
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:
Yesterday I was configuring transactional replication between two databases on different servers. The servers are on different...