Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jagpalsingh4@gmail.com
Starting Member
3 Posts |
 Posted - 2008-04-09 : 08:44:24
|
| Hi,can anybody help me that how can we see sql server Health check with t-sql.Because i am trying to make script for this Basically i need these info..1.Current Date 2.Current time 3.Session,id 4.Session name 5.all locks 6.cpu utilization 7.how much disk space is used inside the database 8.how much space is free inside the database 9.Date read10 Date write 11.how can we see process information with t-sql or with stored procedure and i have solved 6 problems from this list i made queries for this .will u plz help me thaxxxjagpal singh |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 12:47:19
|
| Check DMV(Dynamic Management View) in SQL server 2005. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 23:15:58
|
| You need date read/write for what? Each row? Sql doesn't keep that. |
|
|
|
|
|
|
how to see health check in sql server