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 |
|
Zindros
Starting Member
3 Posts |
 Posted - 2011-11-04 : 15:38:05
|
| Dear All,I would like to share your experience and views to the following problem:1. SQL 2005 is running on Intel Xeon E5430 @ 2.67 Ghz (4 CPUs), 3.00 GB of RAM with Microsoft Windows Server 2003 R2 std edition sp22. There are dailly batch jobs and around 20 on line users3. Every night we re-create and update index statistics4. The DB is around 12 Gbytes to drive D:5. Only SQL server is running to the machineSeveral days the users are complaining because the system is slow. The performance is not as usual. The tasks everyday are approximately the same.We run SQL monitor software and we found out that the memory used by SQL is around 2.5 - 2.8 Gbytes. Network utilization and disk activities seem Ok.Has anybody any suggestions how to identify what bothers the machine and occasionally is slow ? |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-05 : 12:53:22
|
| http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/This should be a good place to identify what is eating resources. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-11-06 : 01:39:11
|
| 3 GB of RAM ?? Are you in the 90's ???SQL is using 2.5 to 2.8 GB of RAM which leaves like how much 0.3 to 0.5 GB for OS..If I remember properly even windows vista needs 1 GB to run properly.Right now problem is not with SQL but server memory.PBUH |
|
|
|
|
|
|
SQL PERFORMANCE