SQL server error - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL server error

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-12-15 : 20:58:12

Hi,
One of our developer got surprised error today when she is using CLR with sql server 2005.

Msg 6513, Level 16, State 27, Line 2 Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.

Can you pls explain what exactly this error is for ? Searched google didn't find much useful info.

Thanks,
Gangadhar

Thanks,
Gangadhara MS
SQL Developer and DBA

chadmat
The Chadinator

1974 Posts

Posted - 2010-12-18 : 02:23:11

There is obviously memory pressure. How much memory is on ther server? Is it 32 or 64 bit?

-Chad

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-12-19 : 23:14:56

Server is SQL server 2005 Enterprise edition and we are having 32 GB of RAM (PRODUCTION SERVER)

Thanks,
Gangadhara MS
SQL Developer and DBA

chadmat
The Chadinator

1974 Posts

Posted - 2010-12-20 : 01:41:18

64 bit or 32?

-Chad

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-20 : 03:00:14

From the error, you have 32 bit SQL without AWE enabled. If that's the case, that SQL server can use no more than 2 GB of that 32 GB of memory.

--
Gail Shaw
SQL Server MVP

chadmat
The Chadinator

1974 Posts

Posted - 2010-12-21 : 00:06:24

Gail,

Unfortunately, you cannot draw that conclusion based on that message, I have seen it when this was no thte case.

-Chad

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-12-22 : 22:14:30

Hi All,
Again today i have got with the same error:

Error:[Microsoft][ODBC SQL Server Driver][SQL server] Failed to initialize the common Language Runtime(CLR) v2.0.50727 due to memory pressure.Please restart SQL server in Address Windowing Extensions(AWE) mode to use CLR integration features
Code:80040E14
Source: Microsoft OLEDB Provider for ODBC Drivers

We are using SQL server 2005 EE 32 bit with Windows server 2003 enterprise edition with 32 GB of systems memory.

Please help me to identify the root cause.

Thanks,
Ganga

Thanks,
Gangadhara MS
SQL Developer and DBA

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-23 : 03:36:46

Do you have AWE enabled? If not, that SQL Server is using no more than 2 GB of the 32 GB of memory available.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources