SQL State 40001 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL State 40001

Author

Topic

Kimono
Starting Member

3 Posts

Posted - 2008-10-27 : 00:30:44

Hello!,

One of our databases (vmware virtualcenter) is generating these on it's 30minute performance rollup job. However, when I run the job manually by clicking "start job" it works a treat.

How to diagnose the cause?

thnx

Executed as user: dbo. Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-27 : 00:35:11

On SQL jobs, I just add retries to the job steps when I see deadlocks happening occassionally.

To figure out what's really going on though, you'll need to follow the instructions in SQL Server Books Online that talking about troubleshooting deadlocks.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kimono
Starting Member

3 Posts

Posted - 2008-10-27 : 22:15:53

OK thanks for that.

Any particular reasons why it would start happening randomly? Virtual center upgrades are always fraught with bad SQL scripts that leave muck or go wrong... So maybe I'll have to tear the DB apart and see what's missing...

Or could it be a case of "under resourced SQL server"? ( it is kinda old now)

[/quote]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources