Posted by Erland Sommarskog on 06/09/05 00:26

EJO (5p1der@centurytel.net) writes:
> In query analyzer and profiler, there seem to be system processes that
> are generating high cpu time and disk io.

They don't look particularly high to me. CPUTime is in milliseconds, so
10 seconds in five days is not a lot. And 2400 disk IO for the checkpoint
process looks like a calm system to me...

> There are also several domain controlled logins that appear to be on the
> same host name, at the same time--these are laptops, not terminal
> servers--why would the system be reporting such a thing?

An application can set the host name when the connection, and can
blatantly like if it wishes to.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: When changing to type text from nvarchar, the 255 character limit is maintained?
• Prev in forum: Re: How to find transposed data and near misses
• Thread view: Re: sp_who2 output

[Reply to this message]