Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Engine   (RSS)

SQL Server (2000, 2005, 2008): Recovery/Rollback Taking Longer Than Expected

I have blogged on the various ways to determine the state of recovery but this week I was involved in an interesting discussion around rollback. The transaction has run for 14 hours and then a KILL SPID was issued. The SPID goes into rollback and happed
Posted by psssql | 2 Comments
Filed under:

SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs

  SCENARIO SQL Server fails to install a WOW64 instance (x86) an on a computer with more than 32 CPUs.    During setup you will encounter a SQL Server failed to start message.      SQL Server is attempting to determine the
Posted by psssql | 1 Comments
Filed under: ,

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: , ,

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different
Posted by psssql | 5 Comments

How It Works: Creating An EndPoint Adds An Entry To SysLogins

My SQL Server does not have individual windows users established as separate logins.   Instead it has the Domain\SQLUsers group established as a WINDOWS GROUP login.  You can review your mappings using the following DMVs. select * from
Posted by psssql | 1 Comments
Filed under: ,

Using Locking Like Synchronization Object

This post is more of a T-SQL trick and NOT a recommendation practice, but since I addressed this in a recent customer case I thought I would share it. Problem:   Application needs to lock a row for the duration of the transaction and ensure no data
Posted by psssql | 2 Comments
Filed under: ,

IsNumeric Returns (1/TRUE) and I Expected (0/FALSE)

The string '100,200,300' has fooled many a customer and support engineer alike. select cast('100,200,300' as bigint) Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to bigint. One might argue that this is a bigint value.  However,
Posted by psssql | 2 Comments
Filed under:

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page
Posted by psssql | 1 Comments
Filed under: , ,

How It Works: Attention, Attention or Should I say Cancel the Query and Be Sure to Process Your Results

I ran into this issue the other day and decided it would make a good post.  Since I have seen this issue more times that I can count I will again attempt to provide details. The attention event in SQL Server trace output indicates a query cancellation.  
Posted by psssql | 2 Comments

SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

While attempting to install SQL Server 2005 you may encounter an error familiar to the following and a retry option presented by setup. Faulting application sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, faulting module sqlservr.exe, version

SQL Server reports operating system error 1450 or 1452 or 665 (retries)

Overview The error: 1450/1452 insufficient system resources exist to complete the requested service. These are not a SQL Server based errors. The error cause is related to a depleted system resource (non-paged pool, paged pool ,...). These issues have

SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

The mistake I see people make is when looking at the SQL Server PAGE I/O waits and stalled I/O warnings is when comparing it to the Avg. Disk Seconds/Transfer.    Everyone seems to forget that average means average and they look at the

How It Works: Trace (.TRC) File Security

SQL Server 2000 shipped with different trace file security than later builds of SQL Server 2000, SQL Server 2005 and SQL Server 2008. The SQL Server process (sqlservr.exe) writes the trace files to the specified destination.   The SQL Server
Posted by psssql | 3 Comments

How It Works: More on DBCC Shrink* Activities

My peers are starting to tease me about becoming a dbcc shrink* expert. (Ha, Ha I said.)  Then, I uncovered another design facet about shrinkfile helping with a SQL Server 2000 case.  The situation:     dbcc shrinkfile, with EMPTYFILE,
Posted by psssql | 1 Comments
Filed under: ,

Query Performance issues associated with a large sized security cache

In the past couple of months, SQL Server support team has come across some customers running into performance issues attributed to TokenAndPermUserStore in SQL Server 2005. This blog post attempts to compile all the information we have so far regarding
More Posts Next page »
 
Page view tracker