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 |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2008-11-18 : 11:48:18
|
| I have a SQL Server 2005 Workgroup Edition installed on a Window 2003 SP2 32-Bit OS with 4GB of RAM. This instance is dedicated to a thirdparty tool called Orion SolarWinds.We have noticed a degradation in performance lately. To begin the application is constantly poling and adding information to the database but running SQL profiler doesn't indicated any thing evident.Perfmon indicates that the page file is constantly being used. I am kind of new to the world of troubleshooting. I am hoping someone has some knowledge on what I can do to improve performance or point me at some good articles to help me troubleshoot and resolve my issues.Any help would be greatly appreciated. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-11-18 : 12:18:55
|
| This is not an exhaustive list....1. have you got hardware errors....or database corruption. look at the DBCC commands.2. how long since the server (or SQL) has been rebooted?3. have any changes been made to the environment?4. is it "poor all over"....or just in a "few places"?5. do you have base-line performance benchmarks to back up or refute the "observations"6. what sort of data volumes are you talking about?7. what's the code look like?....and please don't say CURSORS?8. are appropraite indices in place on all tables?9. are you experiencing any locking/blocking?Unless you learn fast re Profiler, you may be looking at hiring an expert for on-site support for a quick fix/problem investigation just to buy you time to get overthe current hump, while you skill up on Profiler. |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-18 : 12:26:30
|
| a very helpful document (download .doc file)http://www.sqlteam.com/article/troubleshooting-performance-problems-in-sql-server-2005 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-18 : 17:35:15
|
| Check standard reports that comes with SQL Server and tune the queries that comes evident with appropriate indexes |
|
|
|
|
|
|
Performance Tuning Help