RML Questions

  The following questions have surfaced several times recently so I decided to post the answers to assist others.   String is missing proper closing quote near (Char Pos: 0xC1 Byte Pos: 0x182) This is not a utility bug.   It is a command found in the trace that was malformed.  For example:   select * from…

1

Inside the SQL Server Clinic…

In my last post, I reviewed the Microsoft CSS involvement at the upcoming 2011 SQL Server PASS Summit. One big part as I’ve mentioned is the SQL Server Clinic. I thought you might find it interesting to learn more about exactly what the clinic is and how you can make the best use of it….

2

The SQL PASS Summit comes again to Seattle and CSS will be there…

For the 9th year, the Microsoft CSS team will speak and meet customers at the SQL PASS Summit, being held  this year in Seattle, Washington from October 11th through the 14th. As in past summits, CSS will have a presence during pre-conference seminars, the main conference, and our infamous SQL Clinic. I’ll be posting more…


The DMV sys.dm_os_memory_clerks May Show What Appears To Be Duplicate Entries

In SQL Server 2008 some of the memory based DMVs show memory node id 0 when you might not expect them to.   For example you could see the following on a single, node system. SQL 2008 memory_clerk_address  type                      name    memory_node_id 0x0000000003EF6828    MEMORYCLERK_SQLBUFFERPOOL Default 0 0x0000000005040828    MEMORYCLERK_SQLBUFFERPOOL Default 0 SQL 2008 R2 memory_clerk_address type                      name    memory_node_id…

1

SQL Server 2008/2008 R2 on Newer Machines with More Than 8 CPUs Presented per NUMA Node May Need Trace Flag 8048

Applies To:  SQL 2008, 2008 R2 and Denail builds The SQL Server developer can elect to partition memory allocations at different levels based on the what the memory is used for.   The developer may choose a global, CPU, Node, or even worker partitioning scheme.   Several of the allocation activities within SQL Server use the CMemPartitioned…

10

How compressed is your backup?…

While working recently with a  customer, it was brought to my attention that while SQL Server has a great feature to compress backups (introduced in SQL Server 2008), the space consumed by the backup before it is complete may not be as expected.  To be more precise, when you backup a database using compression, the…

5

Stored procedure recompile caused by alter table on temp table

Lately we got a customer who called in and reported  that a particular statement involving a temp table always got recompiled and caused performance problems.   We have a KB article http://support.microsoft.com/kb/243586  which documents various scenarios that will cause recompile involving temp tables. But none of the conditions seemed to match.  After digging deeper, we were…

2

How It Works: Return codes from SQLIOSim

I have been asked how to automate SQLIOSim on several occasions.  SQLIOSim is a utility to test SQL Server I/O integrity (not performance) patterns against a system without needing to install SQL Server on the system.  It ships with SQL Server 2008 and SQL Server 2008 R2 and is located in the BINN directory. There…

1

Trace shows the incorrect Session Login Name

The is more of an FYI blog post but I have read several blog and forum posts on this subject and I decided to dig into the behavior which revealed a trace bug. For the vast majority of events the Session Login Name represents the originating session credentials where as the Login Name represents the…

3

SQL Server 2008 R2 does not start when applying certain hotfix updates

We have noticed that when you install certain hotfixes (this includes Cumulative Update 1 and certain versions of security update MS11-049 etc. ) on an SQL Server 2008 R2 RTM Instance on which Utility Control Point is configured, the installer fails to apply the upgrade scripts and SQL Server does not start. You will see…