SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Suspended Transactions.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chaitum323
Starting Member

India
1 Posts

Posted - 10/29/2013 :  06:00:17  Show Profile  Reply with Quote
Hell All,

I am facing an issue with suspended transactions. Due to this problem server the server CPU reaching to 90% and the app is facing some issues on the front end. Here one SPID reaching it's maximim
value (i.e 2147483647) and invoking a new process with same SPID.

Fyi..

223 0 2013-10-19 11:31:37.800 suspended 2147483647
223 0 2013-10-19 11:31:37.800 suspended 2147483647
223 0 2013-10-19 11:31:37.800 suspended 2147483647
223 0 2013-10-19 11:31:37.800 suspended 2147483647
223 0 2013-10-19 11:31:37.800 suspended 2147483647

How can I restrict these queries in a way that they never reach the max CPU value or not going into suspended state ?

Can anyone please help me on this regard ?

Appreciate your help here.

Thanks
Chetan M

chadmat
The Chadinator

USA
1974 Posts

Posted - 11/04/2013 :  14:45:17  Show Profile  Visit chadmat's Homepage  Reply with Quote
Not sure I understand what is happening, but you can use Resource Gov to limit CPU for a specific application.



-Chad
Microsoft Certified Master SQL Server 2008
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000