unable to Kill a Process

Question

Post reply

unable to Kill a Process

naveen.nagareddy

SSChasing Mays

Points: 628
More actions
November 29, 2010 at 9:12 pm

#99436

Hi,
I am getting the following error while trying to kill a process from another session.
"Process ID 61 is not a valid process ID. Choose a number between 1 and 32817"
I have seen the above process in sp_who2 which is taking more time for processing.
Then came to know,unable to kill even a single process.
I am using SQL Server 2000 with SP2 and is on production.
I have executed checkdb command on master, msdb, model. It didn't show any errors.
Please help me in resolving this.
Thanks in Advance.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

I would imagine it is in how you are issuing the kill command.

It sounds like you may be issuing a

Kill -61

And should be issuing a

Kill 61

Here is some info on the error.

http://www.sql-server-performance.com/faq/process_id_not_valid_p1.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 2

Hi CirquedeSQLeil,

Thanks for your quick reply.

I am not using kill -61, please go through the screen shots attached.

Waiting for reply.

Thanks in advance.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Have you tried a checkdb against your user dbs?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 4

Hi CirquedeSQLeil,

Cross checked checdb on all databases, didn't find any error.

Thanks in Advance.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Does this problem exist with the database on a different server?

Have you considered upgrading from SP2 to a more recent SP in 2000?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 6

Hi ,

I took backup and restored the database to a different server.

Kill process is working fine in the server(SQL 2000 with SP2).

previous server and new server are in same configuration.

The same is not working in the previous server.

Please help me in resolving the issue.

Thanks in Advance.

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 7

Hi CirquedeSQLeil,

All the SQL 2000 servers using in my environment are with SP4.

ignore my mistake.

Thanks in Advance.

Adiga One Orange Chip Points: 27284 More actions · Answer 8

Does DBCC CHECKDB on master report any errors?

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 9

Hi Pradeep,

It didn't give any errors.

Thanks in Advance.

Adiga One Orange Chip Points: 27284 More actions · Answer 10

May not be a good question. Was the query running when you were executing KILL?

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 11

Hi Pradeep,

Please cross check the screen shots. It has been running during the time.

Thanks in Advance.

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 12

Hi All,

Can anyone help me on this issue.

Thanks in Advance.

Adiga One Orange Chip Points: 27284 More actions · Answer 13

Is the process still running and you are unable to kill it?

I have not come across a situation where the SPID is valid and I am unable to kill it.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

naveen.nagareddy SSChasing Mays Points: 628 More actions · Answer 14

Hi Pradeep,

The process is not still running, but i am unable to kill single process which is running in the server.

Thanks in Advance.