Perfomance Questions  
Author Message
sgreen1979





PostPosted: Wed Aug 06 13:03:30 CDT 2003 Top

SQL Server >> Perfomance Questions

I have a few questions.

First: We have a quad Xeon 500MHz server running SQL2K
and Win2K. All SPs are applied. Sometimes the
performance becomes an issue. My boss wants me to go
through and kill some processes when that happens. Are
there any adverse reactions to that?

Second: We also have a Terminal Server with Win2k3
running. Does anyone know of any performance issues with
this?

Thanks.
Don

SQL Server190  
 
 
Russell





PostPosted: Wed Aug 06 13:03:30 CDT 2003 Top

SQL Server >> Perfomance Questions Don,

If the solution is to kill processes, you need a better solution.

Killing a process naturally affects the user of that process. Depending on
how the client and T-SQL code is written this can range from harmless but
annoying to leaving data in a logically incomplete state. (It will not
physically corrupt the database, but logical corruption is just as
troublesome.)

The thing to do is investigate the processes that are candidates for
killing, figure out what is wrong, and help the developer/user to correct
the problems. (Famous bad query: multi-table cartesian product to get just
a few rows. Done by people who do not understand joining.)

Russell Fields


> I have a few questions.
>
> First: We have a quad Xeon 500MHz server running SQL2K
> and Win2K. All SPs are applied. Sometimes the
> performance becomes an issue. My boss wants me to go
> through and kill some processes when that happens. Are
> there any adverse reactions to that?
>
> Second: We also have a Terminal Server with Win2k3
> running. Does anyone know of any performance issues with
> this?
>
> Thanks.
> Don


 
 
Martin





PostPosted: Wed Aug 06 14:12:32 CDT 2003 Top

SQL Server >> Perfomance Questions One time I puked because a process was killed.. I couldn't stand it.

MS



> My boss wants me to go
> >through and kill some processes when that happens. Are
> >there any adverse reactions to that?
>
> Other than users losing the work they were doing, no.
>
>
> >-----Original Message-----
> >I have a few questions.
> >
> >First: We have a quad Xeon 500MHz server running SQL2K
> >and Win2K. All SPs are applied. Sometimes the
> >performance becomes an issue. My boss wants me to go
> >through and kill some processes when that happens. Are
> >there any adverse reactions to that?
> >
> >Second: We also have a Terminal Server with Win2k3
> >running. Does anyone know of any performance issues with
> >this?
> >
> >Thanks.
> >Don
> >.
> >


 
 
Don





PostPosted: Wed Aug 06 14:58:29 CDT 2003 Top

SQL Server >> Perfomance Questions Russell,

Thanks for the good detailed information.

Don


>-----Original Message-----
>Don,
>
>If the solution is to kill processes, you need a better
solution.
>
>Killing a process naturally affects the user of that
process. Depending on
>how the client and T-SQL code is written this can range
from harmless but
>annoying to leaving data in a logically incomplete
state. (It will not
>physically corrupt the database, but logical corruption
is just as
>troublesome.)
>
>The thing to do is investigate the processes that are
candidates for
>killing, figure out what is wrong, and help the
developer/user to correct
>the problems. (Famous bad query: multi-table cartesian
product to get just
>a few rows. Done by people who do not understand
joining.)
>
>Russell Fields


>> I have a few questions.
>>
>> First: We have a quad Xeon 500MHz server running SQL2K
>> and Win2K. All SPs are applied. Sometimes the
>> performance becomes an issue. My boss wants me to go
>> through and kill some processes when that happens. Are
>> there any adverse reactions to that?
>>
>> Second: We also have a Terminal Server with Win2k3
>> running. Does anyone know of any performance issues
with
>> this?
>>
>> Thanks.
>> Don
>
>
>.
>