any tool which can tell the load of each database running on a SQL

is there any tool which can tell the load of each database running on a SQL
Server
Please reply asap
Thanks
Pankaj Jain
_________________________________________
Nagarro Software Pvt. Ltd.
3 Type B, Electronics City,
Sector 18, Gurgaon, India - 122015
http://www.nagarro.com
Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
Extn. 205
Fax (+ 91) 124 - 2455304
"This electronic communication and any accompanying document are intended
only for the individual or entity to which it is addressed and may contain
confidential and/or privileged information. If you are not the intended
recipient of this message, be aware that any use, review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error and/or are not the intended recipient,
please notify the sender and delete it from your system. We do not claim
that this information is complete or accurate and any views expressed in
this message are those of the individual sender."
Check this one: http://www.imceda.com/Coefficient_Description.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> is there any tool which can tell the load of each database running on a
SQL
> Server
> Please reply asap
> Thanks
> Pankaj Jain
> --
> _________________________________________
> Nagarro Software Pvt. Ltd.
> 3 Type B, Electronics City,
> Sector 18, Gurgaon, India - 122015
> http://www.nagarro.com
> Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
> Extn. 205
> Fax (+ 91) 124 - 2455304
>
> "This electronic communication and any accompanying document are intended
> only for the individual or entity to which it is addressed and may contain
> confidential and/or privileged information. If you are not the intended
> recipient of this message, be aware that any use, review, dissemination,
> distribution, or copying of this message is strictly prohibited. If you
have
> received this communication in error and/or are not the intended
recipient,
> please notify the sender and delete it from your system. We do not claim
> that this information is complete or accurate and any views expressed in
> this message are those of the individual sender."
>
|||Hi
Thanks but i already saw this and i want some thing that gives me load in
percentage for all the database that exist in the SQL Server at that point
Thanks
Pankaj Jain
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Check this one: http://www.imceda.com/Coefficient_Description.htm.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Pankaj Jain" <pankaj@.nagarro.com> wrote in message
> news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> SQL
intended[vbcol=seagreen]
contain
> have
> recipient,
>
|||Hi,
Did you mean Load in terms of User connections for each databases, then it
is possible.
Select getdate() as Current_time,DB_NAME(DBID) as DBNAME,COUNT(*) from
Master..sysprocesses
Group BY DB_NAME(DBID)
You can schedule the script to execute using OSQL and save it in a fife.
This will give you the amount of users in each database. If needed you can
schedule this script using SQL Agent to run based on specific interval.
Thanks
Hari
SQL Server MVP
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:uKXIbxoNFHA.2520@.tk2msftngp13.phx.gbl...
> Hi
> Thanks but i already saw this and i want some thing that gives me load in
> percentage for all the database that exist in the SQL Server at that point
> Thanks
> Pankaj Jain
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
> message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...
> intended
> contain
>