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 |
|
runnerpaul
Starting Member
24 Posts |
 Posted - 2012-05-22 : 04:12:42
|
| Hey,I'm beginning to investigate (and hopefully fix) SQL Server performance issues but as this is my first time doing such an investigation I would appreciate any advice/pointers people might have.Initial stats are as follows:Windows 2003 Server R2 Standard x64 edition(SP2)Intel Xeon CPU 1.86Ghz, 1.87Ghz25.7GB RAMSQL Server 2005 Standard editionMin Server Memory = 128MBMax Server Memory = 20000MBC:\ = 44.9GB with 16.7GB freeD:\(SQL Data) = 533GB with 5.43GB freeE:\(Avamar Data) = 255GB with 85.7GB freeL:\(SQL Logs) = 132GB with 39.9GB free.As I say, I'm not sure where to begin. Could anybody please advise? If you require more info I can get it for you.CheersPaul |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-22 : 06:36:38
|
| When you asy you're having performance issues, what exactly do you mean?CPU, memory..?----------------------------Junior DBA learning the ropes |
 |
|
|
runnerpaul
Starting Member
24 Posts |
Posted - 2012-05-22 : 06:52:35
|
| Its just that SQL seems to be running very slowly.I suppose naturally it is using all the memory allocated to it. |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-22 : 07:16:52
|
| That's still a little vague but you could start by using profiler to see what's running. This should give you an indication as to what might be using the resources.Has the system suddenly become slow? Do you rebuild your indexes periodically?----------------------------Junior DBA learning the ropes |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-22 : 07:24:07
|
| These links might help:[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]----------------------------Junior DBA learning the ropes |
|
|
|
ovc
Starting Member
35 Posts |
Posted - 2012-05-22 : 16:57:51
|
| there are a lot of problems which have to be taken into consideration for the analysis. Are there certain queries which are taking long or just some of them?If you are interested I could help you guide through such an analysis and guide you through. I have already posted something a few days before something... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=174918 |
|
|
|
|
|
|
SQL Server Performance Investigation