MS SQL Server - some infrastructure

Author

some infrastructure

prem

2005-09-28, 8:23 pm

hi all,
we are designing a application to work along with sql server 2000.

we are looking for the ability to recognize, by t-sal code, all sql servers
running in the network.
I heard that there is a local component on each machine called "listener".
I'd love to get a few tips/ links of how to.. work with it.(or any other idea)

another thing, we are also looking for a way to monitor the logs (the ones
under the managment folder in enterprise manager) via t-sal.
for now, our best idea is to import the log files into a table (using bcp
and format files) and the to read from the table, but I can imagine there are
better ways.

and, is there a way to monitor (again with sql code) current system values
(for example: cpu usage levels , disk performance.....)

thanks,
prem

Jerry Spivey

2005-09-28, 8:23 pm

Prem,

I'm not sure of a way to do this with T-SQL. You might take a look at the
ListAvailableSQLServ
ers method in SQL-DMO. I'm not sure if this method
lists SQL Servers that have been hidden via the TCP/IP dialog Hide Server
option. Also, you might check out the -L argument of the OSQL utility.

Again...it's not T-SQL but you might find the findstr utility useful for
scanning the errorlogs for errors. See:

INF: How to Scan SQL Errorlog or DBCC Output for Errors
http://support.microsoft.com/kb/q115519/

HTH

Jerry
"prem" <prem@discussions.microsoft.com> wrote in message
news:286C16CF-D44E-4F6F-9FBF- E3A77213D373@microso
ft.com...
> hi all,
> we are designing a application to work along with sql server 2000.
>
> we are looking for the ability to recognize, by t-sal code, all sql
> servers
> running in the network.
> I heard that there is a local component on each machine called "listener".
> I'd love to get a few tips/ links of how to.. work with it.(or any other
> idea)
>
> another thing, we are also looking for a way to monitor the logs (the ones
> under the managment folder in enterprise manager) via t-sal.
> for now, our best idea is to import the log files into a table (using bcp
> and format files) and the to read from the table, but I can imagine there
> are
> better ways.
>
> and, is there a way to monitor (again with sql code) current system values
> (for example: cpu usage levels , disk performance.....)
>
> thanks,
> prem
>
>

Jerry Spivey

2005-09-28, 8:23 pm

Actually...now that I think about it you could probably call OSQL -L with
xp_cmdshell and INSERT..EXEC to do this in t-sql.

HTH

Jerry
"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:en1x%23AIxFHA.720@TK2MSFTNGP10.phx.gbl...
> Prem,
>
> I'm not sure of a way to do this with T-SQL. You might take a look at the
> ListAvailableSQLServ
ers method in SQL-DMO. I'm not sure if this method
> lists SQL Servers that have been hidden via the TCP/IP dialog Hide Server
> option. Also, you might check out the -L argument of the OSQL utility.
>
> Again...it's not T-SQL but you might find the findstr utility useful for
> scanning the errorlogs for errors. See:
>
> INF: How to Scan SQL Errorlog or DBCC Output for Errors
> http://support.microsoft.com/kb/q115519/
>
> HTH
>
> Jerry
> "prem" <prem@discussions.microsoft.com> wrote in message
> news:286C16CF-D44E-4F6F-9FBF- E3A77213D373@microso
ft.com...
>
>

Sponsored Links