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.
| Author |
Topic |
|
chaitum323
Starting Member
1 Post |
 Posted - 2013-10-29 : 06:00:17
|
| 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 2147483647223 0 2013-10-19 11:31:37.800 suspended 2147483647223 0 2013-10-19 11:31:37.800 suspended 2147483647223 0 2013-10-19 11:31:37.800 suspended 2147483647223 0 2013-10-19 11:31:37.800 suspended 2147483647How 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
1974 Posts |
Posted - 2013-11-04 : 14:45:17
|
| Not sure I understand what is happening, but you can use Resource Gov to limit CPU for a specific application.-ChadMicrosoft Certified Master SQL Server 2008 |
 |
|
|
|
|
|
Suspended Transactions.