Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works   (RSS)
Thursday, September 17, 2009 3:08 PM

How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?

The ring buffer records (which can be sent to XEvent) for Resource Monitor and Memory Broker are the key aspects to understanding RM.  The record is produced when a change is detected in state monitored by RM.    CREATE EVENT SESSION RingBufferInfo
Posted by psssql | 0 Comments
Wednesday, July 08, 2009 5:03 PM

Q&A on Latches in the SQL Server Engine….

I recently received a request to shed some light on a few advanced questions about latches and SQL Server. These were good questions so I thought the information might be useful to share with the community. I’ll provide this information in the form of
Posted by psssql | 1 Comments
Tuesday, June 16, 2009 6:18 PM

SQL Server on Windows 7 / Windows 2008 R2 with more than 64 CPUs

The release of the Windows 7/Windows 2008 R2 will support more than 64 CPUs. It is also documented that the SQL Server 10.5 (Kilimanjaro - http://news.cnet.com/8301-13860_3-10236936-56.html ) will extend the SQL Server Engine to support more than 64 CPUs.
Posted by psssql | 1 Comments
Friday, May 29, 2009 6:30 PM

How It Works: SQL Server Timings and Timer Output (GetTickCount, timeGetTime, QueryPerformanceCounter, RDTSC, …)

A series of questions related to start time, duration, end time, T-SQL waitfor delay command and others crossed my path again this week.     As I was trying to explain it to a fellow engineer and I realized it has become a bit complicated.
Posted by psssql | 1 Comments
Filed under: , , ,
Tuesday, May 26, 2009 10:43 PM

How It Works: SQL Server Engine Exception Handling

I was recently asked how SQL Server handles exceptions in the core code of the engine. I looked around at various references and did not find a concise document. When an exception is encountered in SQL Server error details such as the following are inserted
Posted by psssql | 1 Comments
Filed under:
Thursday, May 21, 2009 6:57 PM

How a log file structure can affect database recovery time

We frequently come across situations where databases take a long time to recover. A common scenario is where the recovery process has to roll forward or back several transactions for a database after a SQL Server restart. However, you might also see one
Posted by psssql | 3 Comments
Filed under: ,
Friday, May 15, 2009 5:00 PM

How It Works: DBCC MemoryStatus Locked Pages Allocated and SinglePageAllocator Values

I have recently had several questions related to the dbcc memorystatus and associated memory DMV display values for locked pages and single page allocations.   After reviewing several outputs and the code I will attempt to summarize my findings.
Posted by psssql | 1 Comments
Filed under: , , ,
Tuesday, March 17, 2009 3:38 PM

How It Works: What Are The Event Source Names Used By SQL Server

  Sent: Tuesday, March 17, 2009 4:24 AM Subject: Event Source changed from MSSQLServer to MSSQLSERVER to all upper case   Our different SQL server versions write to the Eventlog in a mixture of upper/lower case.  One version writes as Event
Posted by psssql | 1 Comments
Filed under: , , , ,
Tuesday, March 03, 2009 9:57 PM

How It Works: SQL Server - VDI (VSS) Backup Resources

Last week I worked on an interesting case.   The issue was a NT Backup against a single volume containing 500 SQL Server databases.  It is rare to have so many databases on a single volume but it is possible and we had a case on this very
Posted by psssql | 3 Comments
Tuesday, March 03, 2009 9:23 PM

How It Works: Almost Everything You Wanted To Know About The SQL Server (2005, 2008) Performance Counter Collection Components

I will be posting a troubleshooting companion to this 'How It Works' that outlines the associated troubleshooting steps for SQL Server base performance counter collection issues.    This post attempts to highlight the various components of the
Posted by psssql | 2 Comments
Filed under: , , ,
Monday, February 23, 2009 3:37 PM

How It Works: Resource Governor 'INTERNAL' Group

From: Customer Sent: Friday, February 20, 2009 2:04 PM I have seen sometimes a user connection classified as Internal when I run the following query:   USE master ; SELECT sess . session_id , cast ( sess . login_name as varchar ( 40 )) login_name
Posted by psssql | 1 Comments
Filed under: ,
Wednesday, February 11, 2009 7:52 PM

How It Works: File Stream Compression with Backup/Restore

The question of file stream compression during backup and restore arose last week and makes for a good clarification topic. Shown here is a conceptual layout of a database containing file stream containers.    On the left the folders represent
Posted by psssql | 2 Comments
Monday, February 02, 2009 2:37 PM

Why aren't my subscriptions working?

I ran across an interesting issue the other day with subscriptions not firing.  I had never ran across this before, but once I was done it made sense.  It was also a good exercise of walking through how subscriptions work.  This may be
Posted by psssql | 1 Comments
Wednesday, January 28, 2009 3:17 PM

Hot It Works: SQL Server SuperLatch'ing / Sub-latches

SQL Server Books Online uses the terms super latches and sub-latch to describe them.   For example the SQL Server:Latches performance counter group calls them super latches.   The DVM that exposes the super latches use the term sub-latch,
Posted by psssql | 1 Comments
Filed under: ,
Thursday, January 22, 2009 7:44 PM

How It Works: Statistics Sampling for BLOB data

I worked on an interesting issue today and the outcome deserves a post.  The issue was that when auto update statistics executed the query went from 6 seconds to 6+ minutes. select count(*) from tblImageData where blobData is null Turing on the SP-:StmtStarting
Posted by psssql | 1 Comments
More Posts Next page »
 
Page view tracker