Solved

How to get memory usage per database

Posted on 2003-11-04
4
310 Views
Last Modified: 2006-11-17
How to write the Stored Procedure to get the memory usage per database, which Stored Procedure in master database can be called to get those kind of information?

or

Is there a tool to monitor the memory or CPU usage per database?
0
Comment
Question by:hlqyang
4 Comments
 
LVL 3

Accepted Solution

by:
htarlow earned 50 total points
Comment Utility
for cpu usage

run sp_who2 and sum up the cpu usage by database.
0
 

Expert Comment

by:kauf
Comment Utility
I think you can get the mem-usage trough the masters sysprocesses table, you can group & sum to the database id there...
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now