Database Statistics
-
Hello All,
Is there any way I can obtain statistical results in SQL 2k either by something that’s built in or by using a 3rd party utility? I’m looking to possibly provide statistical results on things like total number of users, queries, etc.
thanks,
Ronnie
-
I assume you are talking about usage statistics for the server. Using SQL Profiler you can trace activity in SQL Server, but that does have some effect on the performance of the server. You can use System Monitor to log various performance counters that might help you. There are also some simple functions you can use, such as @@CONNECTIONS which tells you the total number of attempted connections since the server was started.
If you can specify more in detail what you are looking for maybe we can give a more specific answer.
-
use the following sps
sp_who
sp_ monitor
also
slect * from syslogins
to know total no. of users.
-
You'd have to build something or use a product like SQLCentric, BMC's Patrol, etc.
-
You could also look at Microsoft's new SQL Health and History tool.
This tool captures information about the Server and Database and with the add-on Performance collecter, it captures any Performance counter you specify.
--------------------
Colt 45 - the original point and click interface
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply