SQL Server Internals: Hardware and processes

How do we query the server hardware from SQL Server? When was the SQL instance last started? What processes are running on the SQL Server? We can all of this using a set of fairly simple queries, if you know where to look!

Duration:	3 mins 15 secs
Skill Level:	100
Rating:	3.92 out of 5
Publish Date:	December 16, 2009

SQL Server Internals: Hardware and processes

You must be logged in to view this video.

12345
1=Poor, 3=Good, 5=Excellent

About the Author

Schooled and worked as a .NET developer / DBA in the USA, currently working as a DBA in the Nordic countries at sqlservice.se.

References

There are no downloads or recommended reading links for this video

Comments

valluru raghu on 12/29/2009

excellent

Philip Grooms on 12/29/2009

Good Information

Mike on 12/29/2009

didn't like zoom in/out usage -- but still informative

Thomas Kelley on 12/30/2009

Thanks, I agree a little zoomy, but great info. Also, can you post your scripts when you put these together?

Bob McLeod on 12/30/2009

Very good information and well presented.

Mark Weichman on 12/30/2009

you should give another second or two to show clearly each of the SQL statements...you were just a little too quick with that

aks on 1/2/2010

Very basic info..

RangeValidator on 1/5/2010

Too much zooming in and out.

Ed Svastits on 1/7/2010

Great description of how to get the information. I could use a bit more information on what the listings mean.

Must Be Logged In