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 |
|
chicks2001
Starting Member
15 Posts |
 Posted - 2003-04-23 : 09:22:18
|
| There is so much to learn and I have read some contradictory articles about Installation, monitoring and hardware what is right and what is best I was wondering if perhaps someone might be able answer the following for me. That is if there is an answer.What do you feel is the best strategy for monitoring the performance of your SQL Server 2000 installation?What hardware components are involved in successful monitoring of a database installation? What can be done within the database itself to increase performance? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-24 : 12:48:30
|
| I'm confused by your questions. Do you want to know about the performance of the actual installation or the performance of the SQL server? For the SQL Server, I always use Performance Monitor/System Monitor (using SQL Server counters) along with SQL Profiler. For hardware components, I always use Performance Monitor/System Monitor (using the hardware counters). To increase the database performance, one has to consider the database design, indexes, data, etc... To help with this, use SQL Profiler. HTH,Tara |
 |
|
|
chicks2001
Starting Member
15 Posts |
Posted - 2003-04-24 : 18:01:09
|
| Yes I was wondering about the best strategy is for monitoring my sQL server. You mentioned in your reply that you use the performance monitor/system monitor. I am not sure what you mean by counters can you explain or tell me where I can look it up? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-24 : 18:14:38
|
| Performance Monitor (NT4 name) / System Monitor (Win2k name) is a tool that allows you to figure out what the current performance of your server is. To use it, you must select which objects that you want to monitor. For instance, say you want to monitor memory and physical disk, so you select these two objects. Well under these two objects are various counters so you need to select the specific ones that you care about such as Pages/sec for memory and % Disk Read Time for physical disk.Have a look at this site for a more thorough explanation (links are at bottom):[url]http://www.sql-server-performance.com/[/url]TaraEdited by - tduggan on 04/24/2003 18:15:28 |
|
|
|
|
|
|
|
|
SQL Instalation/Monitoring