I've had it happen when the nightly tape backup overlaps with the sql full, or log backup, so also check this process.

Other references in this forum that may be related to your issue:

http://www.sqlservercentral.com/Forums/Topic763709-146-2.aspx#bm861251

http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx

Here's a reference:

http://technet.microsoft.com/en-us/library/cc966401.aspx

Don't forget about the disk subsystem. What are the queue lengths? How do the overall disk counters look?

If the passive node is going to be used for failover then "YES" you would need to enable "lock pages in memory" for this node.

Also, if your service account is...

I've been randomly having this error during backups, update_stats, and updates (database grooming). The timings of this work does not overlap so it's not that. We are connected...

mark.veitch (2/1/2010)

---

The user data is input using a different application over which I have no jurisdiction. This is the reason we have gone this way. I could do...

Thanks, Steve.

#1 seems reasonable. If one of the cart items fails to process, you then wouldn't submit this as part of the payment which would eliminate a "credit" issue.

You could always do this on the application side after the user input and prior to the db call.

My previous job was that of an Air Traffic Controller, so the DBA stress doesn't compare.

You have to find routines to "get away" for a bit. I like to...

Did you UPDATE_STATS after the upgrade? This can make a big difference when moving from SQL 2000 to 2005

I had the same issue and this post resolved it. Here's another post about the subject.

http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx

and as Dale said, running this fixes it.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ sysdbupg.sql

You may want to try SQLIOSIM as the tool for testing.

http://support.microsoft.com/kb/231619

and another tool is IOMETER.

We recently completed testing on the HP LeftHand SAN and it didn't meet our...

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

Exactly.

My MIS degree program devoted 2 semesters (courses) to Systems Analysis and Design.