Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

How to get memory usage per database

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
hlqyang
Asked:
hlqyang
1 Solution
 
htarlowCommented:
for cpu usage

run sp_who2 and sum up the cpu usage by database.
0
 
kaufCommented:
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now