February 11, 2010 at 1:55 am
Dear All,
One of our application is too slow sometimes.
When I open SQL Server Error Log I am seeing the following messages.
Process ID 'x' was killed by hostname XYZ, host process ID 'xxx'.
There are tooo many such messages. Whats actualy it means..? And what to do on this ? Please guide. It's very urgent.
Thanks in advance.
February 11, 2010 at 2:05 am
Someone (who's using a computer with the name given in hostname XYZ) is running the KILL command and killing processes.
Find the person and tell them to stop.
That's likely not the cause of the slowness, that's likely someone killing processes to resolve the slowness. What you really need though is some performance tuning on your app.
Why is this urgent?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2010 at 2:17 am
Killing other people's processes without notice is administering in a very bad way, nonetheless.
Calling something urgent without explaining is frowed upon on SSC. Did people die from it?
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
February 11, 2010 at 2:23 am
Yes. Infact none is doing deliberately as such.
almost 100 people using an application (MS Navision). Processes are killed by application itself I think.
Now how to go about it.?
I have read enough abot performance tuning and have started accumulating the necessary data. But still can you just brief me the steps I need to do for tuning it.?
Probably for this particulare issue especialy.?
It's urgent because client is in remote location.
DB Size is 256 GB, SQL Server 2005 with SP3, Windows 2003 server.
Thank you somuch.
Awaiting your reply.
February 11, 2010 at 2:29 am
Joy Smith San (2/11/2010)
I have read enough abot performance tuning and have started accumulating the necessary data. But still can you just brief me the steps I need to do for tuning it.?
Performance tuning's a massive, complex area. There's no step-by-step instructions, it's not that easy. Plus, if you're using a 3rd part app (Navision) you may not be allowed (by the licences) to change any of the indexes or queries.
Take a look at these.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2010 at 2:34 am
No.. We can customise it. We have the licence for that.
We can do anything we want in database (apart from some base tables). I have analysed the trace in DTA. Couldn't find any index issue...it dint suggest any missing indexes.
February 11, 2010 at 3:26 am
The fact that DTA doesn't find anything, doesn't mean that there isn't opportunity for improvement. DTA is questionable at best.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply