Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQ
L
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help "Skylander" <Skylander@.discussions.microsoft.com> wrote in message
news:10710AC1-A2C8-45D1-9CE5-A7032970D502@.microsoft.com...
> I am new to the forum and have a question. I would like to monitor the
SQL
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the
SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks
in
> advance for your help
There are a variety of monitoring options available, from high-end to basic:
Microsoft Operation Monitor (MOM), network monitor, performance monitor,
home grown application.
Also, you'll want to give this article a read:
http://support.microsoft.com/defaul...kb;en-us;827422
Steve