MySQL SHOW STATUS equivalent in MSSQL

Hi,
I am looking for an equivalent query that will give me similar results to the MySQL "SHOW STATUS" query.
Thanks!
LVL 1
shji1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
robertjbarkerConnect With a Mentor Commented:
exec sp_monitor has packets_received, packets_sent, packet_errors, total_read, total_write, total_errors, and connections.  These are not exactly, but are close to many of the things you seek.
0
 
robertjbarkerCommented:
exec sp_monitor might be a start.

I think you will have to look up individual things more than in MySQL.  Looks like MySQL is a little more organized in this area.

Are you looking for something in particular?  Best thing might be to get into the on-line help and search for the particular property you are interested in.
0
 
shji1Author Commented:
I need to get more data about the server-status.
MySQL gives me plenty of it, and I am trying to get something similar.
For example, Iwould like to get the Bytes_sent, Bytes_received, # of questions, memory usage, threads etc.
thanks
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
shji1Author Commented:
I've found the 'EXEC sp_helpdb' which is closer to my intentions, but I need more...
0
 
shji1Author Commented:
Well, I tried it, but I only got 'last_run', 'current_run' and 'seconds' - One row only.
Are you sure it's sp_monitor?
I simply typed exec sp_monitor and this is what I got.
0
 
shji1Author Commented:
And another thing...  Only a System Administrator can execute the sp_monitor, and I can't limit my application to admin only.

0
 
shji1Author Commented:
By the way, I am using JDBC to query the database, and the sp_monitor returns a multiple ResultSets. That is the reason I could not see the rest of the results (only the first).
0
 
robertjbarkerCommented:
The sp_monitor returns four different results sets.  If you execute in query analyzer you will see this.  I would imagine accessing the results depends on the method you are using to communicate with SQL Server.  If you search for sp_monitor, or "multiple result sets", or something like you will get a few results including:

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20383209.html
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20165270.html
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20373521.html

jdbc is not specifically addressed, but you might get something out of it...
0
 
robertjbarkerCommented:
Also, you might be able to wrap sp_monitor in another stored procedure and give that procedure permission to execute sp_monitor.

Or you can consider just consider granting sp_monitor execute permissions to your users.
0
All Courses

From novice to tech pro — start learning today.