Maystyle :
Admin : New post
Guestbook
Local
media
Catergories
Recent Articles
Recent Comments
Recent Trackbacks
Calendar
Tag
Archive
Link
Search
 
  Fail to allocate the more pages on SQL Server. 
작성일시 : 2008. 12. 22. 12:20 | 분류 : SQL Server/Administration

If you want to allocate more files or a extend file size, sometimes SQL Server alert the error.
Msg 5149 Level 16 state 1 1450

I think that is not a SQL Server Problem.
It may be a Windows Performance Problem.

The First : Insufficient of Nonpaged Pool or Paged Pool
For locate file system, Windows's cache manger using the System Pools.
but System Pool's (Nonpaged Pool and Paged Pool) Size is fixed when the windows is booting.

Related Article : http://support.microsoft.com/kb/274310, http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

The Second : Insufficient of Disk or MFT
Although you have sufficient disk storage, MFT may be full.
You can monitoring your MFT Size on Disk Manager.

Related Article : http://support.microsoft.com/kb/174619/

PS.
I Found the article about this situation.
Oh my GOD.
Thx SQL Server CSS Team...^^
http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx

|