none
120 gb ServiceManager.mdf running disk space out on disk...

    Question

  •   Hello, I have a problem with disk space; Hardware Requirements says Service Manager database need at least 80gb available, we have 130gb partition to SQL but servicemanger.mdf is growing to fast and dont release space. SCSM version is 7.0.5826.886 (CU3 applied). There is someway to limit the growing or force DW sync to release space?.

    Thanks in advance.
    Victor Gacitua C.
    CHILE

    Thursday, September 30, 2010 8:11 PM

Answers

  • there is a known issue related to that stored proc. we are working on a fix. you should get in touch with CSS and open a case at this point.
    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Monday, October 25, 2010 8:26 PM

All replies

  • Can you run the following query on the ServiceManager database (using SQL Server Management Studio) and return me the output?

    Thanks.

    SELECT

     

    TOP 100 i.name, OBJECT_NAME(i.object_id), dps.used_page_count, dps.in_row_used_page_count, dps.lob_used_page_count, dps.row_overflow_used_page_count, dps.row_count

    FROM

     

    sys.dm_db_partition_stats dps

    LEFT

     

    JOIN sys.partitions p

     

    ON dps.partition_id = p.partition_id

    LEFT

     

    JOIN sys.indexes i

     

    ON p.index_id = i.index_id AND p.object_id = i.object_id

    ORDER

     

    BY dps.used_page_count DESC

     


    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Friday, October 1, 2010 10:56 AM
  •   Hi, i have data result in a excel worksheet, how can i send you or post it here?

     Thanks again,
     Victor Gacitua C.
     CHILE
    Tuesday, October 5, 2010 2:04 PM
  • Please email to scsmbeta [at] live [dot] com.  I'll send it over to Murat.  Thanks!

    Please put the URL of this thread in your email message.


    Travis Wright Senior Program Manager Microsoft
    Tuesday, October 5, 2010 3:17 PM
  •  Thanks Travis. Mail just gone right now.

      Travis, do you know if there some company in CHILE with experience on SCSM? I think my company is the only one deploying SCSM.


     Thanks again,

     Victor Gacitua C.
     Ingeniero de Proyectos
     Policomp S.A.
     CHILE

    Tuesday, October 5, 2010 3:38 PM
  • Thanks!  I have forwarded it to Murat.
    Travis Wright Senior Program Manager Microsoft
    Tuesday, October 5, 2010 4:22 PM
  • Some of the tables that should be groomed seem to be quite large. Either your grooming workflows are not running, or workflows in general are not running.  For further diagnosis can you run the following queries:

    SELECT

     

    TOP 1000 * FROM InternalJobHistory with(nolock)

    ORDER BY 1 DESC

    -- SUBSCRIPTIONS

    SELECT

     

    * FROM CmdbInstanceSubscriptionState WITH(NOLOCK)

    SELECT

     

    * FROM ImplicitUserRoleAdministratorState WITH(NOLOCK)

    SELECT

     

    MAX(EntityTransactionLogId) AS MaxETLIdInETL FROM EntityTransactionLog WITH(NOLOCK)

    SELECT

     

    MAX(EntityTransactionLogId) AS MaxETLIdInECL FROM EntityChangeLog WITH(NOLOCK)

    SELECT

     

    MAX(EntityTransactionLogId) AS MaxETLIdInRECL FROM RelatedEntityChangeLog WITH(NOLOCK)

    You can email the output to the same email address. Thanks.


    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Wednesday, October 6, 2010 8:56 AM
  •   Hi Murat, i just send new XLSX with results to Travis at scsmbeta. Please if you need more information contact to me at vgacitua (at) policomp (dot) com.

    Thanks a lot again.

    Victor Gacitua C.
    Policomp S.A.
    CHILE 

    Wednesday, October 6, 2010 4:08 PM
  • Forwarded the new one to Murat.
    Travis Wright Senior Program Manager Microsoft
    Wednesday, October 6, 2010 4:19 PM
  • We are getting close. Two more queries to execute:

    SELECT

     

    *

    FROM

     

    MT_GroomingConfiguration

    SELECT

     

    *

    FROM

     

    dbo.PartitionAndGroomingSettings

     

     


    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Thursday, October 7, 2010 10:40 AM
  • Hi Murat, i just send the file to scsmbeta. I´ll be stand by for some answer. Thanks a lot. Victor Gacitua C. Policomp S.A. CHILE
    Friday, October 8, 2010 5:13 PM
  • Hi Victor, thanks for running all these queries for us and sending the results.  I've passed the latest on to Murat.  Here is another query for you to run please:

     

     

    SELECT

    MP.MPName,

    R.RuleName,

    W.State,

    W.EventCount,

    W.LastNonZeroEventCount,

    W.LastModified,

    MT.TypeName,

    RT.RelationshipTypeName,

    RMT.TypeName AS RelatedTypeName,

    R.RuleEnabled,

    CONVERT(xml, MP.MPXml) AS ManagementPackForRule,

    W.*

    FROM dbo.CmdbInstanceSubscriptionState AS W INNER JOIN dbo.Rules AS R ON W.RuleId = R.RuleId INNER JOIN dbo.ManagementPack AS MP ON R.ManagementPackId = MP.ManagementPackId LEFT OUTER JOIN dbo.ManagedType AS MT ON W.TypeId = MT.ManagedTypeId LEFT OUTER JOIN dbo.RelationshipType AS RT ON W.RelationshipTypeId = RT.RelationshipTypeId LEFT OUTER JOIN dbo.ManagedType AS RMT ON W.RelatedTypeId = RMT.ManagedTypeId WHERE W.State <> (SELECT MAX(EntityTransactionLogId) FROM dbo.EntityChangeLog) ORDER BY MP.MPName, R.RuleName

     

    Thanks!


    Travis Wright Senior Program Manager Microsoft
    Saturday, October 9, 2010 2:17 AM
  •   Hi Travis, i just send the resultant files. There are two because result format is little strange.

    Again, thanks a lot.

    Victor Gacitua C.
    Policomp S.A.
    CHILE

    Wednesday, October 13, 2010 12:05 AM
  • Hi Travis, Murat, did files are usefull? There is some activity we can do for troubleshoot the "non grooming" database?. Right now we are at disk space limit, database is about 150gb and we dont have more space to free.

    Thanks in advance.

    Victor Gacitua C.
    Policomp S.A.
    CHILE

    Friday, October 15, 2010 3:19 AM
  •  Hi people... any news on this??? Im a little worry about this because there is no more space to free on disk and performance is slow on remote consoles.

    I will appreciate any help.

    Victor Gacitua C.
    Policomp S.A.
    CHILE
    Monday, October 18, 2010 4:31 PM
  • Please people, right now performance is terrible, read access from SQL is slowing down all systems. Database consumed all free space at disk and there is no more available, database size now is 162gb, so grew 42gb in less than a month!!! What can we do??? We are managing purchase new disks to make new arrangement but this is a step solution.

    Any ideas is welcome.

    Victor Gacitua C.
    Policomp S.A.
    CHILE

    Tuesday, October 19, 2010 8:53 PM
  • Hi Victor -

    I can't find the query results file you sent for this query:

     

    SELECT

    MP.MPName,

    R.RuleName,

    W.State,

    W.EventCount,

    W.LastNonZeroEventCount,

    W.LastModified,

    MT.TypeName,

    RT.RelationshipTypeName,

    RMT.TypeName AS RelatedTypeName,

    R.RuleEnabled,

    CONVERT(xml, MP.MPXml) AS ManagementPackForRule,

    W.*

    FROM dbo.CmdbInstanceSubscriptionState AS W INNER JOIN dbo.Rules AS R ON W.RuleId = R.RuleId INNER JOIN dbo.ManagementPack AS MP ON R.ManagementPackId = MP.ManagementPackId LEFT OUTER JOIN dbo.ManagedType AS MT ON W.TypeId = MT.ManagedTypeId LEFT OUTER JOIN dbo.RelationshipType AS RT ON W.RelationshipTypeId = RT.RelationshipTypeId LEFT OUTER JOIN dbo.ManagedType AS RMT ON W.RelatedTypeId = RMT.ManagedTypeId WHERE W.State <> (SELECT MAX(EntityTransactionLogId) FROM dbo.EntityChangeLog) ORDER BY MP.MPName, R.RuleName

     

     

    Can you please resend to scsmbeta [at] live [dot] com?


    Travis Wright Senior Program Manager Microsoft
    Thursday, October 21, 2010 12:27 PM
  •  Hi Travis, i just resend files resultants to scsmbeta. Please i need some light in this case, right now system is unresponsive and we have service down. At this moment no consoles can retreive data from server and if we look at SQL process this is the blocking process:  "ServiceManager.dbo.p_RelatedEntityChangeLogInserTion;1"... I dont know if this is usefull for troubleshoot.

     Please help us.

    Victor Gacitua C.
    Policomp S.A.
    CHILE

    Thursday, October 21, 2010 5:33 PM
  • thanks Victor - I have forwarded the results to Murat and Varsha.
    Travis Wright Senior Program Manager Microsoft
    Friday, October 22, 2010 4:22 AM
  • Victor,

    I believe you have some custom subscription rules that Service Manager isn't able to process efficiently. This also prevents the product to groom old data. Is it possible for you to disable the subscriptions you have created? And see if that helps.

    Thanks.


    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Friday, October 22, 2010 11:35 AM
  •   Thanks Murat, i disabled all notifications and subscriptions rules and restart SCSM server, system work fine for almost five minutes and then lock again. Process locking all in SQL is "ServiceManager.dbo.p_RelatedEntityChangeLogInserTion;1". We have no service right now.

    Thanks again.

    Victor Gacitua C.
    Policomp S.A.
    CHILE

    Friday, October 22, 2010 7:23 PM
  • there is a known issue related to that stored proc. we are working on a fix. you should get in touch with CSS and open a case at this point.
    o------------------------- o This posting is provided "AS IS" with no warranties, and confers no rights. o Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm o-------------------------
    Monday, October 25, 2010 8:26 PM