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 |
|
tjwent69
Starting Member
30 Posts |
 Posted - 2007-08-10 : 12:26:46
|
| Hello, I am going to try my best to explain. I have a SQL Server 2003 Enterprise SP1 Production box with 4 Intel(R) Xeon 3.4 GHz CPU's and 4 G Ram. I have a 4G SQL db on a RAID. I have been trying to figure out what is causing my SQLserver Process (sqlserver.exe) to occationally max out all 4 of my processors and basically stop all production. This is what I know.....I use Reporting services with known poorly written reports. That I cancel. and can get performance up.I have a sales force that replicates dB's when more than 6 get going I can see that and know why the dB chokes. I call them and get performance up.I had index problems but now rebuild them at month end. Lately we are having this problem without all of the above being the culprits. Found the Memory Bottle neck post and have the perfmon running. I have two htm one with the max values and one from the very start of this request. I can see that the processor time is high but I don't know what to do. I want to find out specifically what is maxing out these processors.Suggestions and guidance needed. I also have no idea how to get the word documents with the two reports. So I will need some help there as well. Tracy |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-10 : 12:33:18
|
| >>I had index problems but now rebuild them at month end. Can you rebuild them more often - like every other weekend? If you still see issues then you can take out the SQL Server out of the equation and look into hardware..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tjwent69
Starting Member
30 Posts |
Posted - 2007-08-10 : 12:57:23
|
| Wait a min. It is replication. I read the screen wrong. Bad day for telling time I guess. Why would replication of 1 computer do this? August 1st I had 25 computers pull down all new publications all across the state of Nebraska. Two day's ago I was doing the replication install of 1 computer and it maxed out the processors. I have no errors just a message: The process is running and is waiting for a response from the server.Well, this started my quest for performance monitoring and that is where I came across the memory bottleneck topic and set up the perfmon. I want to know what is making the server too slow to talk to the replication system.Tracy |
|
|
|
tjwent69
Starting Member
30 Posts |
Posted - 2007-08-10 : 13:10:06
|
| I will rebuild the indexes tonight. I can do them everyday. That is not a problem. Can I rebuild them while the database is in use? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 01:31:36
|
| That may cause blocking. |
|
|
|
|
|
|
SQL Server Performance