SQL Problem???

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

From: Kevin (Kevin_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 13:35:02 -0700

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

  • Re: SQL Problem???
    ... this could be caused by the workload governor kicking in causing the ... > 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)
  • SQL doesnt exist or access denied
    ... RESTORE DATABASE DB_2 ... files DB_2.mdf and DB_2.ldf on another server msde then I used ... "System.Data.SqlClient.SqlException: ... I don't know if it's SQL problem or if it's .NET application problem ...
    (microsoft.public.sqlserver.server)
  • System.Data.SqlClient.SqlException: SQL doesnt exist or access denied
    ... I performed a restore database in order to have a copy and ... files DB_2.mdf and DB_2.ldf on another server msde then I used ... "System.Data.SqlClient.SqlException: ... I don't know if it's SQL problem or if it's .NET application problem ...
    (microsoft.public.sqlserver.msde)
  • AD 2000 and SQL
    ... I had to rename a user in AD because she got married. ... When I go to the SQL ... So I tried to add the name to SQL server but it will not let me because it ... this is a AD problem and not a SQL problem. ...
    (microsoft.public.win2000.active_directory)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)