| Author |
Topic |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-04-16 : 23:07:33
|
| Hi friends,My SQL server database is using only 1.61 GB of RAM out of 6 GB.It is dynamicaly set.The server is dedicated to SQL database having 2 instances (Cluster)Can I set it manually atleast to 3 GB (50% of total memory) |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-17 : 01:30:46
|
| Buffer Cache Hit ratio is also going down frequently.Even cache hit ratio gets down it won't increases the alloted memory dynamically.Please help. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-18 : 06:29:16
|
| On a dedicated box, use everything but one gig of RAM for the OS. That would give you 2.5 per instance. You need to set it seperately for each instance.Also, look at sql-server-performance to see a list of services you can disable. A lot of the default windows services are not needed and can save you on memory and processor utilization.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-20 : 05:51:11
|
| Thanks.I should not use the dynamic configurations, right?So I should configure a value for"Use a fixed memory size" and "Reserve physical memory for SQL. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-20 : 07:37:08
|
| also make sure your 'awe enabled' is set correctly in sp_configure. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-20 : 07:58:04
|
quote:
Originally posted by bobanjayan
Thanks.I should not use the dynamic configurations, right?So I should configure a value for"Use a fixed memory size" and "Reserve physical memory for SQL.
Right.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-20 : 07:58:43
|
| But one more doubt.We are using Win 2000 Advance server & Sql 2000.If the memory is configured for dynamic usage, it should use it properly, right?What is the problem, it is using 1.62GB only.Why it behaves like that? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-20 : 08:00:52
|
| There could be a lot of reasons. What's your total memory utilization at? Have you looked at the total memory utilization for both instances? Do you have AWE enabled?You need to have the /3GB /PAE switches in your boot.ini file. You also need to have AWE enabled on SQL Server. You then need to set your memory right. MSDN actually has a really good article about this. Go to the SQL Server area and type in AWE memory.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-21 : 01:46:56
|
| I set the Use a fixed memory size to 4050 MBReserve physical memory for SQL to 3072 MBServer got hung. The users were not able to connect.There was a lot of phone calls. I reverted it back.But still 'awe enabled' is set to 1.When users are connecting the cpu utilization is going to 90-100%. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-21 : 02:26:05
|
| I forgot to give the error message." Reason General Network Error. Check your network documentation.ConnectionOpen(PreLoginHandshake())...Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the SQLCLUSTER node) and try again."The above error had given by SQL when I tried to connect through Enterprise Manager. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-04-22 : 02:33:36
|
| We are using Citrix Server.Is there any relation on Citrix Server with 100% CPU utilization? |
|
|
|
|
Memory Usage