on nt4

I know this sounds oldish but the fact is I have Sql Server 2000 installed
on an NT4 machine. Everything works correctly exept Sql Server stops by
itself after a certain amount of time, irrigularly. There is nothing in the
log of the server of the machine.
Is there another tool that I could use to find out why this appends.
thanks
Fernand
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02Hi,
Could you please monitor your resource utlization (Memory in particular)
using performance monitor. Check the usage of virtual memory as well.
Look into the Event viewer as well as SQL server error logs for any messages
or errors.
As well as check you have the latest service pack applied for SQL 2000.
Latest is SP3a
select serverproperty('productlevel')
Thanks
Hari
MCDBA
"Fernand St-Georges" <fernand.st-georges@.videotron.ca> wrote in message
news:nWmQc.5869$DP2.32555@.wagner.videotron.net...
> I know this sounds oldish but the fact is I have Sql Server 2000 installed
> on an NT4 machine. Everything works correctly exept Sql Server stops by
> itself after a certain amount of time, irrigularly. There is nothing in
the
> log of the server of the machine.
> Is there another tool that I could use to find out why this appends.
> thanks
> Fernand
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02
>|||I am not familiar with your sayings. What do you mean by Event viewer. On
XP it is easy to figure out, but on Nt4 the Log that I found did not give
any indication, not even the fact that I restarted Sql Server.
I will also install Sp3.
thanks
Fernand
"Hari Prasad" <hari_prasad_k@.hotmail.com> a écrit dans le message de news:
emOBT4seEHA.2440@.tk2msftngp13.phx.gbl...
> Hi,
> Could you please monitor your resource utlization (Memory in particular)
> using performance monitor. Check the usage of virtual memory as well.
> Look into the Event viewer as well as SQL server error logs for any
messages
> or errors.
> As well as check you have the latest service pack applied for SQL 2000.
> Latest is SP3a
> select serverproperty('productlevel')
>
> Thanks
> Hari
> MCDBA
>
> "Fernand St-Georges" <fernand.st-georges@.videotron.ca> wrote in message
> news:nWmQc.5869$DP2.32555@.wagner.videotron.net...
> > I know this sounds oldish but the fact is I have Sql Server 2000
installed
> > on an NT4 machine. Everything works correctly exept Sql Server stops by
> > itself after a certain amount of time, irrigularly. There is nothing in
> the
> > log of the server of the machine.
> > Is there another tool that I could use to find out why this appends.
> >
> > thanks
> >
> > Fernand
> >
> >
> >
> > --
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02
> >
> >
>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02|||Hi,
Event viewer -- Which stores all the System , Application and Security logs.
Go to Start -- Programs -- Administrative tools -- Event viewer-- Click the
Log menu to see the other logs.
Thanks
Hari
MCDBA
"Fernand St-Georges" <fernand.st-georges@.videotron.ca> wrote in message
news:olnQc.6942$DP2.35920@.wagner.videotron.net...
> I am not familiar with your sayings. What do you mean by Event viewer.
On
> XP it is easy to figure out, but on Nt4 the Log that I found did not give
> any indication, not even the fact that I restarted Sql Server.
> I will also install Sp3.
> thanks
> Fernand
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> a écrit dans le message de news:
> emOBT4seEHA.2440@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Could you please monitor your resource utlization (Memory in particular)
> > using performance monitor. Check the usage of virtual memory as well.
> > Look into the Event viewer as well as SQL server error logs for any
> messages
> > or errors.
> >
> > As well as check you have the latest service pack applied for SQL 2000.
> > Latest is SP3a
> >
> > select serverproperty('productlevel')
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> > "Fernand St-Georges" <fernand.st-georges@.videotron.ca> wrote in message
> > news:nWmQc.5869$DP2.32555@.wagner.videotron.net...
> > > I know this sounds oldish but the fact is I have Sql Server 2000
> installed
> > > on an NT4 machine. Everything works correctly exept Sql Server stops
by
> > > itself after a certain amount of time, irrigularly. There is nothing
in
> > the
> > > log of the server of the machine.
> > > Is there another tool that I could use to find out why this appends.
> > >
> > > thanks
> > >
> > > Fernand
> > >
> > >
> > >
> > > --
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02
> > >
> > >
> >
> >
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.733 / Virus Database: 487 - Release Date: 2004-08-02
>