Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sp_monitor

  
   Database Help (Home) -> Client RSS
Next:  Performance Monitor  
Author Message
naissani

External


Since: Jan 21, 2005
Posts: 7



(Msg. 1) Posted: Thu Feb 10, 2005 2:40 pm
Post subject: sp_monitor
Archived from groups: microsoft>public>sqlserver>clients (more info?)
Sp_Monitor


Here I have a following information about Statistics but can any one let me
know either this is ideal one or not.

last_run current_run
seconds
------------------------------------------------------ ------------------------------------------------------
-----------
2005-02-10 13:52:29.790 2005-02-10
13:53:05.590 36

cpu_busy io_busy idle
------------------------- ------------------------- -------------------------
0(0)-0% 0(0)-0% 1147(34)-94%

packets_received packets_sent packet_errors
------------------------ ------------------------ ------------------------
65(1) 64(1) 0(0)

total_read total_write total_errors connections
------------------- ------------------- ------------------- ------------------
295(2) 71(2) 0(0) 21(0)

Thanks

 >> Stay informed about: sp_monitor 
Back to top
Login to vote
David Gugick

External


Since: Sep 21, 2004
Posts: 118



(Msg. 2) Posted: Thu Feb 10, 2005 3:40 pm
Post subject: Re: sp_monitor [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Doesn't appear to have much going on. I don't find sp_monitor all that
useful. You're better off performance tuning using Profiler.

--
David Gugick
Imceda Software
www.imceda.com

 >> Stay informed about: sp_monitor 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
OLEDB: Prepared cmd with NULL input param for NOT NULL INT.. - Provider: SQLOLEDB Version: SQL Server 2000 8.00.760 Script for creating table: CREATE TABLE [dbo].[ADRVERTRETER] ( <font color=purple> ; [ROWID] [timestamp] NULL ,</font> <font color=purple> ; [ROWVERTRETER] [int] NO...

[MS Design Tools] - Class not registered.&quot; - On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstall...

Need help choosing front end for SQL Server - I've been working on an Access 97 database that's pretty much reached it's limit in terms of performance and reliability. Although it supports relatively few users (5-10 concurrent) it contains a lot of data (around 30 tables, some with several million..

SQL server tables read-only to ADP - I have successfully migrated an Access 2003 database to SQL server - at least all the tables and queries that resolve into views migrated successfully. I also sucessfully migrated all my forms and code into an ADP project. Everything works with one..

Opening table in SQL Server 2005? - This ought to be easy. But I can't figure out how to do it. Using Enterprise Manager in SQL Server 2000, I point to a table, select it, right click and choose Open Table-> Return all rows. Now I have the table open and I can edit to my heart's..
   Database Help (Home) -> Client All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]