+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / DB Optimization

DB Optimization

8 posts, 0 answered
  1. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    07 Sep 2010
    Link to this post
    What can I do to get a sql 2005 sitefinity DB to work faster?

    I'm trying to figure out why a site sometimes takes 6-20 seconds to display on a reload

    1) Caching is enabled
    2) Not in debug mode

    Could it just be fragmented?
  2. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    07 Sep 2010
    Link to this post
    Here's the fragmentation situation

    sf_CmsControlProperty   PK_sf_CmsControlProperty   100
    sf_VrsTxtData   TextData_Parent_idx   99.3975903614458
    telerik_Users   PK_telerik_Users   99.3548387096774
    sf_CmsWebControl   PK_sf_CmsWebControl   99.3485342019544
    sf_CmsControlProperty   CmsControlProperty_Parent_idx   99.2770292474532
    sf_WebControlBase   PK_sf_WebControlBase   99.2756710694504
    sf_CmsControlProperty   CmsControlProperty_ParentProperty_idx   99.1542488924688
    sf_Activity   Activity_Type_idx   99.0857142857143
    sf_Activity   PK_sf_Activity   99.0677542866656
    sf_StagedCtrlLinks   StagedControlLink_Control_idx   98.8023952095808
    sf_CmsControlProperty   CmsControlProperty_ParentProperty_idx   98.4615384615385
    sf_Activity   PersistedActivity_Parent_idx   98.4496124031008
    telerik_UserMetaInfo   PK_telerik_UserMetaInfo   98.4126984126984
    sf_GCMetaData   PK_sf_GCMetaData   98.2456140350877
    sf_StagedPageContent   PK_sf_StagedPageContent   97.9865771812081
    sf_Activity   Activity_Type_idx   97.7272727272727
    sf_CmsCtrlLinks   PK_sf_CmsCtrlLinks   97.6744186046512
    telerik_UserMetaInfo   IX_MetaInfo_DateTime   97.3333333333333
    telerik_UserMetaInfo   IX_MetaInfo_Float   97.3333333333333
    sf_StagedCtrlLinks   PK_sf_StagedCtrlLinks   97.3176865046102
    sf_CmsCtrlLinks   CmsWebControlLink_Control_idx   97.2972972972973
    sf_Notif_Subscriber   PK_sf_Notif_Subscriber   96.969696969697
    telerik_UserMetaInfo   IX_MetaInfo_Integer   96.8253968253968
    sf_StagedPageContent   StagedPage_Template_idx   96.8253968253968
    sf_Activity   PK_sf_Activity   96.7741935483871
    sf_CmsControlProperty   CmsControlProperty_Parent_idx   96.2962962962963
    sf_GCMetaData   IX_sf_GCMetaData_CntPrntID   96.1538461538462
    sf_VrsBinData   BinaryData_Parent_idx   96.1538461538462
    sf_VersionItem   PK_sf_VersionItem   95.4545454545455
    sf_WebControlBase   PK_sf_WebControlBase   95.2380952380952
    sf_GCMetaData   IX_sf_GCMetaData_Integer   95.2380952380952
    sf_GCMetaData   IX_sf_GCMetaData_Float   95.2380952380952
    sf_StagedPageContent   StagedPage_Parent_idx   95
    telerik_Users   User_idx   95
    sf_CmsCtrlLinks   CmsWebControlLink_Page_idx   95
    sf_Notif_GroupSubscriber   GroupSubscriber_Group_lnk_idx   94.4444444444444
    sf_GCMetaData   IX_sf_GCMetaData_Status   94.4444444444444
    sf_Notif_GroupSubscriber   GroupSubscriber_Subscriber_lnk_idx   94.1176470588235
    sf_WorkflowInstance   PK_sf_WorkflowInstance   94.1176470588235
    sf_WorkflowInstance   WorkflowInstance_m_activity_idx   93.75
    sf_Polls_IPData   PK_sf_Polls_IPData   93.75
    sf_CmsControlProperty   PK_sf_CmsControlProperty   93.4678256357032
    sf_PageContentBase   PK_sf_PageContentBase   93.3333333333333
    telerik_Users   User_Application_idx   93.3333333333333
    sf_CmsTextContent   PK_sf_CmsTextContent   93.1818181818182
    sf_CmsPageContent   PK_sf_CmsPageContent   92.8571428571429
    sf_Notif_GroupSubscriber   PK_sf_Notif_GroupSubscriber   92.3076923076923
    sf_GCMetaData   IX_sf_GCMetaData_GuidValue   92
    sf_GCMetaData   MetaData_Parent_idx   92
    sf_lst_ListItem   PK_sf_lst_ListItem   91.6666666666667
    sf_CmsBinaryContent   PK_sf_CmsBinaryContent   91.6666666666667
    telerik_Profile   PK_telerik_Profile   91.6666666666667
    sf_CmsContentBase   PK_sf_CmsContentBase   90.9090909090909
    sf_GCMetaData   IX_sf_GCMetaData_ShortText   90.9090909090909
    sf_GCMetaData   IX_sf_GCMetaData_DateTimeValue   90.9090909090909
    sf_PageBase   PK_sf_PageBase   90
    sf_VersionItem   IX_VersionItem_Label   90
    sf_VersionItem   VersionItem_LockedLnk_idx   90
    sf_StagedCtrlLinks   StagedControlLink_Page_idx   89.8448519040903
    sf_StagedCtrlLinks   PK_sf_StagedCtrlLinks   88.8888888888889
    sf_SecPerms   PK_sf_SecPerms   88.8888888888889
    sf_VrsBinData   PK_sf_VrsBinData   88.5496183206107
    sf_CmsContentThumbnail   PK_sf_CmsContentThumbnail   88.4615384615385
    sf_Polls_IPData   IpAddress_Poll_idx   85.7142857142857
    sf_GCMetaData   MetaData_contentBase_idx   84
    sf_CmsContentBase   IX_ContentBase_Url   83.3333333333333
    sf_StagedCtrlLinks   StagedControlLink_Page_idx   83.3333333333333
    sf_VrsTxtData   PK_sf_VrsTxtData   83
    sf_VersionItem   IX_VersionItem_Modifier   80
    sf_CmsPageProps   PK_sf_CmsPageProps   80
    sf_PageContentBase   PageContentBase_Template_idx   75
    sf_PageBase   IX_PageBase_Name   75
    sf_PageBase   PageBase_Parent_idx   75
    sf_CmsContentVersion   PK_sf_CmsContentVersion   75
    sf_CmsComment   PK_sf_CmsComment   66.6666666666667
    sf_CmsContentVersion   IX_ContentVersion_Modified   66.6666666666667
    sf_CmsContentVersion   IX_ContentVersion_Owner   66.6666666666667
    sf_CmsContentBase   IX_ContentBase_MimeType   66.6666666666667
    sf_CmsContentBase   IX_ContentBase_ParentID   66.6666666666667
    sf_PageContentBase   PageContentBase_Page_idx   50
    sf_lst_ListItem   ListItem_Parent_idx   50
    sf_CmsContentThumbnail   Thumbnail_Parent_idx   50
    sf_CmsContentVersion   ContentVersion_contentBase_idx   50
    sf_CmsContentVersion   IX_ContentVersion_DateCreated   50
    sf_CmsContentVersion   IX_ContentVersion_Status   50
    sf_StagedCtrlLinks   StagedControlLink_Control_idx   50
  3. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    07 Sep 2010
    Link to this post
    Hi Steve,

    All stored procedures and database queries are performed by Nolics and we do not make direct calls to the database. It is not possible to change any of the stored procedures or database queries, because they are controlled by Nolics. There are several changes regarding the performance in Sitefinity 3.7 SP3 ( pages and modules section) and there are small fixes in personalization management that will be available in Sitefinity 3.7 SP4.  If you experience some delay on the front end it is possible that your application pool is being recycled or the response from the SQL server  is not returned on time due to some package transfer or network delay for connection.

    You could try to reduce the database size  which should improve( not significantly ) some  parallel operations. You might also find this post useful Tips to optimize backend pefromance

    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    07 Sep 2010
    Link to this post
    Hey Ivan,
      Yeah I wasn't looking to optimize Sitefinity in any way by changing procedures, I know it uses Nolics :)  But could the fragmentation listed below be causing the massive lag time on some refreshes?

    I've already implemented everything in that article including converting the entire frontend of their site to sprites...

    (although the 2 part last article links are broken)
    http://www.sitefinity.com/blogs/ivandimitrov/ivanposts/10-05-17/tips_to_optimize_your_website_performance.aspx


    Steve
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    07 Sep 2010
    Link to this post
    Hello Steve,

    Fragmentation generally appears when you make database queries, which in our case are made by Nolics. You could run DBREINDEX but we have not tested such scenarios and I cannot tell you whether this will not cause some issues with Nolics.

    I fixed the links, now they should work.



    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    07 Sep 2010
    Link to this post
    So this site (telerik.com) doesn't have any maintenance plans or anything going on with it's DB?
  7. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    07 Sep 2010
    Link to this post
    Hi Steve,

    We do not make rebuilds or reindex over Sitefinity's database on Telerik.com

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    08 Sep 2010
    Link to this post
    Gotcha :)

    So then maybe just update to 2008 R2 IIS7.5 and throw some hardware at it? :)

    It's 2003 and IIS6 right now
Register for webinar
8 posts, 0 answered