Re: SQL Problem???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dylan Kruger (carmellobear1_at_hotmail.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 14:26:09 +0200

The query governor does not work like that , check this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0ciq.asp

And

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6dip.asp

this could be caused by the workload governor kicking in causing the
performance issue on your setup

HTH
Dylan

"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:B798068D-AACC-4D78-AE90-357038552CB4@microsoft.com...
> I have system that consists of about 50 workstations; my server is running
> SQL MSDE Ver. 8.00.382. Win2k Server, Sp4, P 998 MHz, 1.7 Gb Mem. My
CPU
> spikes to about 95% and then drops back down to almost nothing. This
happen
> every few seconds. I am getting a what appears to be a great deal of
Page
> faults. We are using the MSDE which I believe is restricted to 8
> simultaneous users. We have more that 8 users logged in the program that
> uses SQL at any given time but we are not receiving errors that too many
> people are trying to access SQL at the same time. The system becomes very
> sluggish at time and we begging to receive errors in the Horizon program.
> Does this sound like a Sql problem? I am not getting any errors in the
event
> logs. . I know how to use Perfmon but I do not know what counter to use
to
> monitor sql server. I do see the sqlservr.exe service is #2 on the CPU
usage
> and mem usage lists. Not sure where to start troubleshooting the problem
> --
> Thanks,

Relevant Pages

  • SQL Problem???
    ... I have system that consists of about 50 workstations; my server is running ... people are trying to access SQL at the same time. ... Does this sound like a Sql problem? ... and mem usage lists. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL --- Group Statement
    ... I was wondering if anyone out there can help me with this SQL problem: ... I have a database that has two tables: EMPLOYEE and JOB_TITLE ...
    (comp.databases.ms-access)
  • Re: How can I improve this code please?
    ... Based on the error you are getting, this is not an SQL problem. ... You ought to be using a command object with parameters for the updated ... > Private Function PrepareStr(ByVal strValue As String) As String ...
    (microsoft.public.sqlserver.programming)
  • RE: (Fwd) How to loop through a database, row by row, and select and update one row at a time
    ... Sounds more like an SQL problem to me. ... They doing this as one SQL statement with an Update select or Join rather that select one subset and iterate over it to update another. ... How to loop through a database, row by row, and select and update ... However, when I put any sort of an update command after that, as in: ...
    (perl.dbi.users)
  • Re: Unauthorized due to ACL on resource
    ... I don't believe that this is a SQL problem. ... I think that the ACL is on the idc/htx file. ...
    (microsoft.public.sqlserver.security)