Welcome to MSDN Blogs Sign in | Join | Help

July 2008 - Posts

Wednesday, July 23, 2008 9:01 PM

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
Wednesday, July 23, 2008 7:45 PM

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
Posted by psssql | 3 Comments
Tuesday, July 15, 2008 5:10 PM

Supporting SQL Server 2008: The system_health session

In my first post on SQL Server 2008, I introduced a new feature called Extended Events (we like to call this Xevent internally). While we were working with the XEvent development team, it dawned on us that we could perhaps build an event session that
Posted by psssql | 1 Comments
Thursday, July 10, 2008 4:15 PM

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
Posted by psssql | 4 Comments
Tuesday, July 08, 2008 2:24 PM

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
Posted by psssql | 1 Comments
Thursday, July 03, 2008 3:36 AM

SQL Server, Windows Server 2008, and the Windows Firewall

Sounds like a movie title. No, it is actually a topic you need to know about if you plan to install SQL Server 2005 or SQL Server 2008 on Windows Server 2008. Instead of me trying to explain the details I would rather you learn from the experts on this
Posted by psssql | 1 Comments
Tuesday, July 01, 2008 9:34 PM

Get Ready for SQL Server 2008

Technorati Tags: SQL Server 2008 , Extended Events Someone who contributes to this blog posted back in April that after the Europe PASS conference they would start in May creating some posts about SQL Server 2008 New Features especially ones related to
Posted by psssql | 1 Comments
 
Page view tracker