RML Utilities for Microsoft SQL Server Released

    The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005.  The utilities are collectively called the RML…

19

RML (READTRACE/OSTRESS) Utilities for SQL Server 2005

As I promised at the PASS 2007 Summit in Denver, I’m writing a post here about the popular RML Utilities better known and READTRACE and OSTRESS. Our goal was to have this fully ready and posted on the web for public download by Thanksgiving. That day has arrived but we are not quite ready to…

3

Do I have to assign the Lock Pages in Memory privilege for Local System?

IMPORTANT: The following KB article adds support for Locked Pages to SQL Server Standard Edition http://support.microsoft.com/kb/970070 NOTE: I’ve updated this because of some questions about 32bit systems.  Some who attended one of my talks at the recent PASS conference asked me the following question “Do I need to use the Group Policy Editor to assign…

15

Database compatibility and new features

Have you attempted to execute queries using some of the new keywords and constructs only to see error messages like the following? Msg 321, Level 15, State 1, Line 5 “sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode…

3

Follow-up to PASS 2007 Summit

Our entire PSS team had a great time presenting and meeting many customers at last week’s summit. Thank you for your interest in SQL Server and bringing so many “interesting” questions to the Service Center. A few follow-up notes for those of you who attended the summit: 1) If you attended one of our pre-conference…

0

Microsoft PSS is back for the PASS 2007 Summit!

Since 2003, Microsoft PSS engineers have been speaking and meeting customers at the PASS Summit. 2007 will be no different. In fact, this year ten of our top PSS engineers are coming into the conference to speak, host labs, and meet customers. I thought I would briefly outline how we will be involved in the summit…

0

SQL Server 2000 with high LOCK_HASH spinlock contention

I want to make you aware of an update (QFE) to address LOCK_HASH contention during logon and sp_reset_connection requests.  The details of the fix are scheduled to be published under knowledge base article 939317.   Customers have generally reported increased than expected CPU and unexpectedly high values for the LOCK_HASH row in dbcc sqlperf(spinstats).   If…

1

SQL Server 2005 – RDTSC Truths and Myths Discussed

I posted some updates to my blog entry about the RDTSC and drift warnings in May.  See the following link  http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx  Because the CPU drift issue has continued to generate questions let me try to answer these directly.   Myth:   Performance Problems   The statement I have seen frequently is that the drift warning equates…

7

NUMA Connection Affinity and Parallel Queries

The SQL Books Online states that using NUMA port affinity helps co-locate the resources used by the query (CPU, Memory, ….).   This is true for serial plan execution but not completely the case for parallel query execution.  You might assume that you can use the NUMA port affinity and all the parallel work is completed…

1

How to configure Database mirroring for use with ODBC applications?

 If you have an ODBC application that is connecting to a mirrored database and if The application uses a connection string without a database name ( for e.g: dsn=ssistest;uid=ssistest;pwd=*********) The DSN is configured to use SQL authentication with a non-blank password. The default database in the DSN configuration is changed to the mirrored database.   You…

1