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 |
|
cacapo
Starting Member
2 Posts |
 Posted - 2012-11-27 : 16:51:46
|
| I have been given the task to gather a multitude of things relating to our servers and their performance to create a data mart. The main problem is that I am fairly new to SQL Server and being a DBA in general and need to write queries/stored procs to get all of the data into a data mart that I have yet to design. It will be a star schema data mart if that helps any. How do I query to find things such as server cpu usage, agent jobs run times, hard disk space, permissions, processors, etc? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-11-27 : 17:18:58
|
| There's a good article here to get started: http://www.sqlservercentral.com/articles/baselines/94656/ |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-27 : 17:50:36
|
| How about MDW, so you don't have to do any of that.-Chad |
|
|
|
cacapo
Starting Member
2 Posts |
Posted - 2012-11-28 : 10:06:18
|
| It is looking like the MDW is the way to go. I am looking into this more. Thanks for the help. |
|
|
|
|
|
|
Collecting Server Metrics