Unable allocate min server memory size to greater than 1GB

MS SQL SERVER

    Sponsored Links

    Next

  • 1. Shrinking Datafile
    First off, I know to not shrink datafiles on a whim, but I do need to reclaim some space in this on Database that is causing me headaches. The datafile was 160 GB, with 33 GB now free. The developers never devised a purge job for archived data. We have now created this purge and are only keeping the last 3 years data so I don't expect the datafile to grow much past the 127 GB that is currently being used. I was able to get it down to 140.5 GB without much problem. Idealy I would like to get it to 130 GB. Any attempts to shrink it below 140.5 GB take multiple hours (8+), even when shrinking by 500 MB at a crack. This is on SQL 200 SP4. FileSizeMB DataUsedMB DataFree 140500.0000 127706.5000 12793.5000 Any suggestions for speeding up the shrinkfile? Thanks! David Hay
  • 2. DATETIME filter
    Hi Folks, I have a table with two columns which are ScheduleDate (datetime), Memory(decimal). Every two minutes a row will be inserted in this table. For table structure and data for 24 hours(720 rows). CREATE TABLE Summary(scheduledate DATETIME,memory DECIMAL(16,2)) DECLARE @i INT,@date DATETIME; SELECT @i=0,@date=GETDATE()-1; WHILE @i<720 BEGIN INSERT INTO Summary VALUES(@date,50 + (100-50)*RAND()); SELECT @i=@i+1, @date=DATEADD(minute,2,@date); CONTINUE; END I need to get avg(memory) of each and every 30 minutes. So i only need 48 rows out of 720 rows in this table. FYI, Its for charting purpose. I need it in a pivot query. like timelines 10:30 11:00 11:30 .... 10:00 memory 92.8 58.9 62.4 Try:1 In this i got only timelines of schedule date not every 30 minute. DECLARE @fromdate AS DATETIME, @todate DATETIME,@timelines VARCHAR(240); SELECT @fromdate='17-Aug-2009', @todate='18-Aug-2009' SELECT @timelines = COALESCE(@timelines + ',[' + CONVERT(CHAR(5),scheduledate,108) + ']', '[' + CONVERT(CHAR(5),scheduledate,108) + ']') FROM summary WHERE scheduledate BETWEEN @fromdate AND @todate GROUP BY CONVERT(CHAR(5),scheduledate,108) SELECT @timelines[Timelines]; Try: 2 Based on row_number I try to filter but MOD is not working in having condition. Thanks in advance. Cheers, Jay..
  • 3. log shipping from sql 2008 to sql 2005
    I heard we can set up the log shipping from sql 2008 to sql 2005 with some work ground , can some give some insight?
  • 4. cannot install SQL 2005 Standard SP3
    Hello: I have looked all over newsgroups for this issue and none of the suggestions are working. I am trying to install SQL 2005 Standard SP3 and it is failing on the database services. The error is "A recently applied update KB955706 failed to install". Again, I have looked up this issue and tried everything. Nothing is working. PLEASE< PLEASE< PLEASE someone help me. childofthe1980s
  • 5. Sql Server 2008 workgroup downgrade
    We recently purchased Microsoft SQL Server 2008 workgroup edition and would like to downgrade to SQL Server 2005 workgroup edition. It appeared that this is something that can be done, but i'm not sure what I should be using for a cd key for the 2005 installation?

Unable allocate min server memory size to greater than 1GB

Postby Sm9lIE5hbQ » Thu, 30 Mar 2006 15:58:01 GMT

I have installed a SQL Sever 2000 Standard Edition with Service Pack 4 on a 
Windows 2003 Standard Server with 2GB memory. But it does not allow me to set 
 the min server memory size that is greater than 1GB.  Do any one know what 
the problem is ? Thx.

Re: Unable allocate min server memory size to greater than 1GB

Postby oj » Thu, 30 Mar 2006 17:52:18 GMT

do you get an error? can you set it via sp_configure? technically, your sql 
can use up to 2GB on win2k3 std. though, this would be unwise 'cuz you have 
to leave some for the OS.

-- 
-oj










Re: Unable allocate min server memory size to greater than 1GB

Postby QW5keSBQcmljZQ » Thu, 30 Mar 2006 23:30:03 GMT

Check the setting for 'max server memory'. 'min server memory' will not be 
allowed to exceed that. Also, with /3gb enabled, 1gb is reserved for the 
Windows kernel. Ensure that in your boot.ini that /3gb or /pae are NOT 
enabled as 2gb of RAM is too low to be using those options (both eat more 
free memory for the extra memory structures).


-- 
Andy Price,
Sr. Database Administrator,
MCDBA 2003









Re: Unable allocate min server memory size to greater than 1GB

Postby Q2hpIEh1bmc » Fri, 31 Mar 2006 11:58:02 GMT

I represent Joe Nam to revise the question.
1. our sql server have set "use a fixed memory size" to 1800M, since the 
total memory of sql server exist 2G.
2. We don't know why the usage of physical memory only allocate below 1G of 
RAM.
Please kindly advise the problem of our sql server setting.
Thank you for all advanced experts.
Chi Hung
2006/3/30









Similar Threads:

1.unable to allocate 'min server memory'

I have SQL2000 Enterprise running on a Win2003 Enterprise machine, with 16GB
of ram....and no other applications. I start the database up and get an
error "unable to allocate 'min server memory'", which doesn't allow the DB
to startup unless I bring the setting down to around 1GB.. Any idea why this
would occur, if I have this much ram?

Thanks for your help


2.Warning: unable to allocate 'min server memory'

I have a Win2k3 EE server with SQL2000EE with 8GB of RAM. /PAE and /3GB
are enabled as well as AWE. Max mem is set to 6144 as is min however
after a reset of the server this warning is appearing:
Warning: unable to allocate 'min server memory'

3.unable to allocate minimum server memory

Hello All,

I have a cluster of two nodes running Windows 2003 Enterprise Edition with 
SQL Server 2000 Enterprise. Each node has 32 GB. And I set the  max server 
memory and min server memory to 28 GB, but the maximum memory was shown only 
16 GB, and SQL Server reports "unable to allocation minimum server memory". 
PAE is in the boot.ini and AWE is enabled in the SQL Server. Any idea?

Thanks in advances

4.SQL2005: Unable to allocate enough memory to start 'Query Processor'

Hi All,

I am using SQL Server 2005. It was working fine.
However all of a sudden I am getting following error.

It fails to start the MSSQLSERVER and SQL Server Agent services with and
error: The request failed or the service did not respond in a timely
fashion. Consult the event log or other applicable error logs for details.

In the log I discover other error:

  a.. Unable to allocate enough memory to start 'Query Processor'. Reduce
non-essential memory load or increase system memory.
Any help or pointer?

Thanks in advance
Sachin


5.max server memory and min server memory (MB) setting

should these parameters be left to the server or should we set the min - max 
according to let's say 90 percent of phyisical memory.
thanks

6. Warning: unable to allocate 'min server memory' of 2000MB.

7. Warning: unable to allocate 'min server memory' of 2258MB.

8. Table Size greater than DB size ?



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 48 guest