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 |
|
california6
Starting Member
38 Posts |
 Posted - 2008-08-08 : 22:02:09
|
| I am trying to understand - How SQL Server 2005-64 bit handle memory? Say if i allocated 20 GB to SQL Server - will it grab 20 GB at instance startup or grab on demand as it required? Can some body please explain on this?Many thanks,Cali |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-08 : 22:11:38
|
| Depends on which edition of SQL Server you have. |
 |
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-08 : 22:30:47
|
| SQL 2005- Enterprise Edition - SP2.Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:20:22
|
| Will grab on demand, and works same way in all editions. |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-09 : 21:21:12
|
| I have assigned SQL to use 20 GB of memory (Fixed) and from the task manager and Total server memory counter i could see - SQL using 20 GB. Now does this mean - SQL Server is under memory pressure? My initial thought is - when you assign memory to SQL 2005 - it grabs on demand. in my situation - given it's using all the assigned memory - does that mean its under memory pressure? Can somebody please share some thoughts here?Many thanks,Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 23:22:10
|
| Not necessare, you have to look at other perfmon counters to find out if there is memory pressure. What's total db size on the server by the way? |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-10 : 14:46:59
|
| what other performance counters i have to look for? my DB size is over 110 GB.Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-10 : 16:50:58
|
| Sqlserver:buffer manager - page life expectancy, Sqlserver:buffer manager - buffer cache hit ratio, Sqlserver:plan cache - cache hit ratio. |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-11 : 14:27:52
|
| Thank you Rmiao for your suggestion.Cali |
|
|
|
|
|
|
Memory