CPU is 99% used by sqlserver

Hi all ,
I have an issue hope you can help:
We have 1 server SQL server 2000 ( Small business )
running with a Pentiem 3 + 1 Go RAM. And we have only 3
Workstation like clients.
Since severals weeks, the CPU od the server is used for
99% and all client request using ACCESS is very slow.
Do you know what happened?
Thanks a lot for your help.
CanCan,
You need to monitor the CPU usage using perfmon counters concurrently
running sql profiler to see whats happening in the background.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"can" <canpama@.netscape.net> wrote in message
news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> Hi all ,
> I have an issue hope you can help:
> We have 1 server SQL server 2000 ( Small business )
> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> Workstation like clients.
> Since severals weeks, the CPU od the server is used for
> 99% and all client request using ACCESS is very slow.
> Do you know what happened?
> Thanks a lot for your help.
> Can
>|||Hi Dinesh ,
Thanks a lot to reply me . I visited your page , it is
nice and fun.
I have another question , i hope that you can help me.
My company has SQL Server 7 and clients using Access to
extract Data from Sql Server.
So my question is:
I would like to migrate all existing applications to Linus
Red Hat , i wonder if we can exporte all data to Postgress
or to My SQL or to DB2 ( Linux ) and i wonder if there are
the same product like ACCESS running with Linux:
Many thank.
Can
>--Original Message--
>Can,
>You need to monitor the CPU usage using perfmon counters
concurrently
>running sql profiler to see whats happening in the
background.
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"can" <canpama@.netscape.net> wrote in message
>news:47c301c37616$eccb9970$a601280a@.phx.gbl...
>> Hi all ,
>> I have an issue hope you can help:
>> We have 1 server SQL server 2000 ( Small business )
>> running with a Pentiem 3 + 1 Go RAM. And we have only 3
>> Workstation like clients.
>> Since severals weeks, the CPU od the server is used for
>> 99% and all client request using ACCESS is very slow.
>> Do you know what happened?
>> Thanks a lot for your help.
>> Can
>>
>
>.
>|||Don't know if you've resolved this already...but I've had this happen on
several servers. It was a virus. I believe it was slammer. The
characteristics of it are similar. Rebooting would recover the CPU for a
while..but it would go back tying up the network, and locking up the server.
If you don't have an SA password...I would bet that it is slammer.
Gary
"can" <canpama@.netscape.net> wrote in message
news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> Hi all ,
> I have an issue hope you can help:
> We have 1 server SQL server 2000 ( Small business )
> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> Workstation like clients.
> Since severals weeks, the CPU od the server is used for
> 99% and all client request using ACCESS is very slow.
> Do you know what happened?
> Thanks a lot for your help.
> Can
>|||Can,
Thanks:)
>>to DB2
Try
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://www.support.microsoft.com/?id=218590
INF: Configuring Data Sources for the Microsoft OLE DB Provider for AS/400
and VSAM
http://www.support.microsoft.com/?id=219077
>>same product like ACCESS running with Linux:
Iam not aware about any.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"can" <canpama@.netscape.net> wrote in message
news:3c1d01c3762a$9d2b7200$a301280a@.phx.gbl...
> Hi Dinesh ,
> Thanks a lot to reply me . I visited your page , it is
> nice and fun.
> I have another question , i hope that you can help me.
> My company has SQL Server 7 and clients using Access to
> extract Data from Sql Server.
> So my question is:
> I would like to migrate all existing applications to Linus
> Red Hat , i wonder if we can exporte all data to Postgress
> or to My SQL or to DB2 ( Linux ) and i wonder if there are
> the same product like ACCESS running with Linux:
> Many thank.
> Can
>
>
>
>
> >--Original Message--
> >Can,
> >
> >You need to monitor the CPU usage using perfmon counters
> concurrently
> >running sql profiler to see whats happening in the
> background.
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"can" <canpama@.netscape.net> wrote in message
> >news:47c301c37616$eccb9970$a601280a@.phx.gbl...
> >> Hi all ,
> >>
> >> I have an issue hope you can help:
> >>
> >> We have 1 server SQL server 2000 ( Small business )
> >> running with a Pentiem 3 + 1 Go RAM. And we have only 3
> >> Workstation like clients.
> >>
> >> Since severals weeks, the CPU od the server is used for
> >> 99% and all client request using ACCESS is very slow.
> >>
> >> Do you know what happened?
> >> Thanks a lot for your help.
> >> Can
> >>
> >>
> >
> >
> >.
> >