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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2007-05-22 : 15:02:03
|
| how can i tell if my SQL has to much of a workload? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-22 : 15:07:00
|
| Use Performance Monitor and SQL Profiler.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2007-05-22 : 15:31:21
|
| what type of tickers do i want to use for preformance monitor? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-22 : 15:43:39
|
| Check out sql-server-performance.com for which counters you should use. Performance Monitor data is fairly complex to analyze. You should purchase a Windows book that specifically deals with performance monitor.IOW, it's too lengthy for us to just start typing here.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2007-05-22 : 15:44:47
|
| a whole book eh? just on one util, OUCH! do you think SQL Profiler will atleast give me an idea if the server is getting it's butt kicked :o) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-22 : 15:45:47
|
| Performance Monitor is the tool to start with.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2007-05-22 : 15:51:40
|
| thank you very much. |
|
|
|
|
|
|
overloaded?