SQLCAT publish new article on transaction log performance..

Read the publication here http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx Also note the new SQL Server 2008 transaction log specification: 1. Amount of “in-flight” I/O Limit. a. SQL Server 2008: limit of 3840K at any given time b. Prior to SQL Server 2008: limit of 480K at any given time


Readtrace updated

In case you haven’t seen this, readtrace has been updated to also support the SQL Server 2008 trace format and new data types.  There are lots of other fixes and changes in there so go and get the latest version to take a look: x64 http://www.microsoft.com/downloads/details.aspx?familyid=B60CDFA3-732E-4347-9C06-2D1F1F84C342&displaylang=en&displaylang=en OR x86 http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en&displaylang=en


Support for more than 64 logical processors

This is a big announcement made at WinHEC http://www.microsoft.com/presspass/features/2008/nov08/11-06winserverr2.mspx  “[…] we continue to invest in scalability. In Windows Server 2008 R2, we have built in support for up to 256 logical processors, which will allow our customers to more fully exploit today’s powerful CPUs, deploying only the features they choose and scaling those solutions to…


New performance monitor counters for SQL Server 2008

I have been looking at some of the new performance counters that are shipped with SQL Server 2008.  Unfortunately some of these are either not well documented or not documented at all.  The list so far consists of: SQL Server Databases: Tracked transactions/sec – Number of committed transactions recorded in the commit table for the…


Making a database clone using SMO

I’ve been playing around with SMO a bit more over the past few days as I’m finding it really useful in some situations.  Following on from previous test with SMO and indexes, I was wondering if I could script the database statistics and histograms in SMO rather than use Management Studio.  As a quick reminder,…


How can I generate a T-SQL script for just the indexes?

I was trying to work out the best way to generate a T-SQL script for only the indexes and I thought that this would be really easy in the Management Studio interface.  I was mistaken.  SQL Server Management Studio also generates scripts for the tables when you want the indexes.  This is not great so…


Finally some guidance on SQL Server and Hyper-V

Just noticed this KB http://support.microsoft.com/kb/956893 which outlines the support policy for SQL Server on Hyper-V.  Bottom line is that SQL Server 2005 is not supported as is failover clustering for both SQL Server 2005 and SQL Server 2008. 



Tablediff is a really handy tool which can be used to fix data sync issues.  It is located in the 90\COM directory.  If you are ever in a situation whereby replica databases are out of sync then tablediff can save your life.  It will compare two tables and generate and output, which includes the T-SQL…