InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:56:37 GMT20http://www.sqlservercentral.com/Forums/Topic667392-65-1.aspx[quote][b]GilaMonster (3/26/2009)[/b][hr][quote][b]Marios Philippopoulos (3/3/2009)[/b][hr]I run the following to get the object name:[code]SELECT object_name(99)[/code]I get the following: [b]ALLOCATION[/b][/quote]It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.This was fairly common to see on tempDB in SQL 2000, not so on user databases. What's the wait time that you're seeing on these waits? If it's a couple milliseconds, don't worry.Are you doing lots of table creation?[/quote]Thank you both for your input. Unfortunately, I don't have the specifics on wait time, but I do know that the waits occur when there is a large insert into a user table. I will post more details next time this occurs, possibly later today.We actually rebooted the server last night. I know, desperate measures, but perhaps that has cleared the problem. I will know some time later today.Fri, 27 Mar 2009 07:09:31 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspx[quote][b]Marios Philippopoulos (3/3/2009)[/b][hr]I run the following to get the object name:[code]SELECT object_name(99)[/code]I get the following: [b]ALLOCATION[/b][/quote]It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.This was fairly common to see on tempDB in SQL 2000, not so on user databases. What's the wait time that you're seeing on these waits? If it's a couple milliseconds, don't worry.Are you doing lots of table creation?Thu, 26 Mar 2009 22:48:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspxI think here is how you find out what to do but I could be wrong because I am on the logical end.[url]https://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/625659.aspx[/url]Thu, 26 Mar 2009 17:13:48 GMTGift Peddiehttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspx[quote][b]Gift Peddie (3/26/2009)[/b][hr][quote]GAM (1:3578624) = ALLOCATED SGAM (1:3578625) = NOT ALLOCATED [/quote]These are in the physical index architecture check below for details from the owners of the relational engine.[url]http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx[/url][/quote]I'm getting object_id = 99 and my query gets hung on this "ALLOCATION" object until I kill it.Is something wrong with the storage engine? What could this mean?Thu, 26 Mar 2009 16:57:12 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspx[quote]GAM (1:3578624) = ALLOCATED SGAM (1:3578625) = NOT ALLOCATED [/quote]These are in the physical index architecture check below for details from the owners of the relational engine.[url]http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx[/url]Thu, 26 Mar 2009 15:56:21 GMTGift Peddiehttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspxAny ideas anyone, I haven't been able to find a satisfactory explanation to this yet.Thu, 26 Mar 2009 15:32:45 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic667392-65-1.aspxI'm having a strange issue while trying to troubleshoot a slow stored procedure.While running the stored procedure, I capture information using the following statement:[code]select * from master.dbo.sysprocesses with (nolock)where spid = 61[/code]Lastwaittype: PAGEIOLATCH_SHwaitresource: 8:1:3639600I then run the following to get the object_id:[code]DBCC TRACEON (3604)DBCC PAGE (8, 1, 3639600, 0)DBCC TRACEOFF(3604)GO[/code]I get this:...m_objId = 99 m_indexId = 0 ...I run the following to get the object name:[code]SELECT object_name(99)[/code]I get the following: [b]ALLOCATION[/b]What is this? I don't have a table by that name in my database.Is there an "allocation" problem in my db, and how can I dig deeper?Here is the full output of the DBCC PAGE command:[quote]DBCC execution completed. If DBCC printed error messages, contact your system administrator.PAGE: (1:3639600)-----------------BUFFER:-------BUF @0x016AA340---------------bpage = 0x5177A000 bhash = 0x00000000 bpageno = (1:3639600)bdbid = 8 breferences = 1 bstat = 0x9bspin = 0 bnext = 0x00000000 PAGE HEADER:------------Page @0x5177A000----------------m_pageId = (1:3639600) m_headerVersion = 1 m_type = 11m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0m_objId = 99 m_indexId = 0 m_prevPage = (0:0)m_nextPage = (0:0) pminlen = 0 m_slotCnt = 1m_freeCnt = 2 m_freeData = 8188 m_reservedCnt = 0m_lsn = (27549:8438:280) m_xactReserved = 0 m_xdesId = (0:0)m_ghostRecCnt = 0 m_tornBits = 2 Allocation Status-----------------GAM (1:3578624) = ALLOCATED SGAM (1:3578625) = NOT ALLOCATED PFS (1:3639600) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:3578630) = CHANGEDML (1:3578631) = NOT MIN_LOGGED DBCC execution completed. If DBCC printed error messages, contact your system administrator.DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/quote]Tue, 03 Mar 2009 09:21:56 GMTMarios Philippopoulos