|
Home > Archive > MS SQL Server > July 2005 > Unable to kill the process
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unable to kill the process
|
|
|
| I try to implement a stored procedure with MDXQuery & OLAP components under
SQL Server Query Analyzer, the first run was always successful. But when I
run another SP under same Query Analyser, it fails. The SQL Query Analyzer
keeps executing my SP and no result turns up.
I have been trying to track down the problem, the sp_who2 shows me that the
status column of SPID is [RUNNABLE], and the command column is [EXECUTE], and
I am not able to kill this process.
As a result, it causes no one is able to access all my reports, but the
server is up for serving other staff.
HELP !!!
| |
| Narayana Vyas Kondreddi 2005-07-21, 7:23 am |
| Use Profiler to see which exact statement your sp is getting stuck on. Track
the events SP:StmtStarting and SP:StmtCompleted. Also see if there's any
blocking going on in your database: SELECT * FROM master..sysprocesses WHERE
blocked <> 0
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Jacky" <Jacky@discussions.microsoft.com> wrote in message
news:2200C15C-E9F7-4741-8049- 2E1C24929DF6@microso
ft.com...
I try to implement a stored procedure with MDXQuery & OLAP components under
SQL Server Query Analyzer, the first run was always successful. But when I
run another SP under same Query Analyser, it fails. The SQL Query Analyzer
keeps executing my SP and no result turns up.
I have been trying to track down the problem, the sp_who2 shows me that the
status column of SPID is [RUNNABLE], and the command column is [EXECUTE],
and
I am not able to kill this process.
As a result, it causes no one is able to access all my reports, but the
server is up for serving other staff.
HELP !!!
|
|
|
|
|