Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works » SQLOS   (RSS)
Wednesday, November 12, 2008 5:31 PM

How It Works: SQLIOSim - Running Average, Target Duration, Discarded Buffers ...

The following is from a lengthy conversation I had with Kevin Kline.  I believe he will be posting more details along with his "Understanding SQLIOSim Output - http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx
Posted by psssql | 3 Comments
Filed under: , ,
Wednesday, September 03, 2008 3:55 PM

How It Works: 17888 - All Schedulers on Node Appear Deadlocked

Error 17888: All schedulers on Node ## appear deadlocked due to a large number of worker threads waiting on <<RESOURCE>>. Process Utilization ##%. SQL Server creates a Scheduler Monitor thread for each node.    One of the Scheduler
Posted by psssql | 1 Comments
Filed under: , ,
Friday, March 28, 2008 8:04 PM

How It Works: Non-Yielding Resource Monitor

I have addressed similar conditions error in a white paper: www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx 2008-01-20 19:01:26.11 Server      ***Stack Dump being sent to K:\MSSQL.3\MSSQL\LOG\SQLDump0001.txt
Posted by psssql | 0 Comments
Tuesday, March 18, 2008 4:42 PM

How It Works: SQL Server 2005 I/O Affinity and NUMA Don't Always Mix

Recently I have fielded several questions related to I/O affinity.  Allow me to outline the behavior and clear up misconceptions. When I/O affinity is enabled SQL Server creates a hidden scheduler for the Log Writer process as well as a special lazy
Posted by psssql | 0 Comments
Filed under: , ,
Wednesday, March 05, 2008 4:51 PM

How It Works: SQLIOSim - Checksums

SQLIOSim, like its predecessor SQLIOStress, is designed to read pages it has written and validate the data.   SQLIOSim does this using a checksum algorithm. When SQLIOSim starts up it creates a set of buffers and used the Cryto APIs to generate
Posted by psssql | 1 Comments
Filed under: , , ,
Tuesday, February 12, 2008 6:10 PM

How It Works: SQL Server 2005 Connection and Task Assignments

I have talked about how connections and tasks get assigned as PASS and during many other mentoring opportunities.  I just finished working on an issue that forced me to dig deeper into the subject. The customer reported that on a NUMA machine the
Posted by psssql | 3 Comments
Filed under: , ,
Thursday, January 24, 2008 6:38 PM

How It Works: SQL Server 2005 NUMA Basics

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. I have received several questions on the SQL Server NUMA implementation this week. Much
Posted by psssql | 1 Comments
Filed under: , ,
 
Page view tracker