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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2007-04-17 : 19:03:03
|
| Hi,I've been running SQL2000 for the past few years with 2gb of RAM and just recently upgraded to SQL2005 with 4 gigs.My old system would always have the sqlservr.exe process using as much RAM as it could, this number would never really drop, maybe if it did it was in the single digit percentages.I was just setting up new maintenance plans on my server, and I noticed from the time I started to the time I finished the SQLSERVR.EXE process dropped from using 3.5gb of RAM to just 1.5GB of RAM right now. It's pretty steadily going up too.Does sql2005 have some new advanced memory management features? Did creating a sql maintenance plan release some memory? Did sqlserver crash ? I've never seen this before.Thanks very much! :)mike123 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-17 : 20:01:43
|
| Did you run some traces to find out why the cpu was high on the old box before you upgraded hardware and software. Perhaps there were some procs using bad query plans/missing indexes/missing statistics..etc When you upgraded, I am assuming you reindexed the entire DB, updated the stats and perhaps one/more of these tasks fixed the issue you had.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SatyaSKJ
Starting Member
46 Posts |
Posted - 2007-04-18 : 04:58:33
|
| As you are playing up with maintenance plan it is better to confirm the service pack level on SQL Server 2005 instance. If the application is compatible with SQL 2005 then its better to check with IOMeter and get it from http://www.iometer.org/ link.Satya SKJSQL Server MVPhttp://www.sqlserver-qa.net |
|
|
|
|
|
|
sql2005 crashing ? memory usuage dropping?