Sql Server Doubt ?

[littlemoon]

Sql server 2008 database lo oka checkpoint SPID undi id is 11 any idea on how to kill this connection by avoiding restarting the sql server ?
motham connections ni slow cheshtundi
kill SPID work avadhu checkpoint ki

[SUbba LIngam]

restart the sql server

[littlemoon]

[quote name='SUbba LIngam' timestamp='1377178064' post='1304148959']
restart the sql server
[/quote]
production server can't restart the server

[bujjulu]

[quote name='SUbba LIngam' timestamp='1377178064' post='1304148959']
restart the sql server
[/quote]
restart>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< is the last solution,

[cherlapalli_jailer]

[gundugadu]

server restart thappithe vere option lenattundi

lets see wat other ppl will say

[SUbba LIngam]

[quote name='littlemoon' timestamp='1377178112' post='1304148960']
production server can't restart the server
[/quote]
jk, idk much abt sql,,,,,,,


help help !

[cherlapalli_jailer]

in my previous project my DBA team used a tool to monitor and kill unwanted connections
i am not able to recollect it..
may be u can google it

[cherlapalli_jailer]

KILL { session ID | UOW } [ WITH STATUSONLY ]


and also

[url="http://www.mssqltips.com/sqlservertip/1473/killing-a-spid-and-checking-rollback-progress-in-sql-server/"]http://www.mssqltips.com/sqlservertip/1473/killing-a-spid-and-checking-rollback-progress-in-sql-server/[/url]

[littlemoon]

[quote name='cherlapalli_jailer' timestamp='1377178574' post='1304148997']
KILL { session ID | UOW } [ WITH STATUSONLY ]
[/quote]
UOW ??

link unda ?

[cherlapalli_jailer]

[quote name='littlemoon' timestamp='1377178643' post='1304149002']
UOW ??

link unda ?
[/quote]
[url="http://technet.microsoft.com/en-us/library/ms173730.aspx"]http://technet.microsoft.com/en-us/library/ms173730.aspx[/url]

[littlemoon]

[quote name='cherlapalli_jailer' timestamp='1377178718' post='1304149009']
[url="http://technet.microsoft.com/en-us/library/ms173730.aspx"]http://technet.micro...y/ms173730.aspx[/url]
[/quote]

idi chusanu already .. checkpoint kada so cant do ..
[color=#2A2A2A]
Use KILL very carefully, especially when critical processes are running. You cannot kill your own process. Other processes you should not kill include the following:[/color][list]
[*]
AWAITING COMMAND
[*]
CHECKPOINT SLEEP
[*]
LAZY WRITER
[*]
LOCK MONITOR
[*]
SIGNAL HANDLER
[/list]

[littlemoon]

ltt

[littlestar]

ltt for lm

[cherlapalli_jailer]

[color=#000000][font=verdana, geneva, lucida,]You do know you're trying to kill a system spawned spid....[/font][/color]

[color=#000000][font=verdana, geneva, lucida,]Anything under 50 is created by sql server...[/font][/color]


[color=#000000][font=verdana, geneva, lucida,][background=rgb(250, 250, 250)]To kill any spid numbered 50 or below, stop the SQL Server Service (a sysadmin can use the SHUTDOWN command).[/background][/font][/color]

[color=#000000][font=verdana, geneva, lucida,]Note that this will also stop [/font][/color][b]all[/b][color=#000000][font=verdana, geneva, lucida,] of the spids, because it stops the server itself, but that is much safer than trying to kill one of the system threads, especially since spid 10 is what does the CHECKPOINT operations![/font][/color]