Post reply

Frequent blocking in SQL Server 2005 instance having Share Point databases

  • July 13, 2010 at 1:13 pm

    #223772

    Hi,

    We have Share Point 2007 SP1 databases in SQL Server 2005 Enterprise edition 64 bit with SP3.

    We are Using Spot light for Monitoring the SQL instance and from last 3 days, I'm seeing the blocking continuously and the blocking duration is in seconds. Please see the attachment.

    Here, all are of same type called CXPACKET and the sessions showing as

    suspended, blocked, blocking

    runnable, blocked, blocking

    I did not see this type of blocking before that same session blocked and blocking itself.

    Is this something specific to Share point databases?

    Is this type of blocking effects the performance?

    If it effects performance, what are the steps to avoid this type of blocking?

    Is something we can do on Share Point side or it should be done on SQL Server side only to avoid this blocking?

    I appreciate your inputs

    Thank you

  • July 14, 2010 at 9:37 am

    #1192916

    Could you please advice me...

    Thanks

  • July 15, 2010 at 10:17 am

    #1193614

    Hi,

    I'm getting calls from users saying that Share Point application running slow!! Is this degrade in performance because of the blocking?

    But this is kind of internal blocking (as same session is blocked & blocking itself?)? can be avoided?

    Please advice....

    Thanks

  • July 15, 2010 at 11:00 am

    #1193639

    SharePoint suffers from known database design issues that can impact performance over time. The use of composite keys and GUID's for clustered indexes requires diligent maintanance. Specific tables will degrade performance if their statistics are not routinely updated.

    Check fragmentation levels on the larger tables in your instance. Depending on usage, defrag and update statistics at least weekly or even nightly in larger installations.

    Dan

  • July 15, 2010 at 11:14 am

    #1193648

    I have verified the Index fragmentation for the Content databases and there are only <10 indexes fragmented (I have considered page count>500

    and I'm Performing Index defrag weekly.

    Auto update stats is on so I'm NOT performing Update stats manually.

    Do we need to perform Update stats manually even if Auto update stats on?

    Is there anything we can do from front end (share point side) to avoid this type of blocking?

    What is the recommend setting for Max degree of Parallelism & Maximum worker threads for SQL Server instance hosting Share point databases?

    For our case Max degree of Parallelism = 0

    Maximum worker threads = 0

    Thanks

  • July 15, 2010 at 11:26 am

    #1193658

    And I also verified the stats that last updated and it is on 4 days ago.

    Is that mean Auto update stats assumes that the stats are up to date and it is NOT required to update stats?

    Please advice

  • July 15, 2010 at 11:32 am

    #1193661

    Auto update stats only gets triggered when 20% of the rows in a table are modified...on small tables, that's fine, but on a big table, say a million rows, 20% is 200,000 rows...a table that size only needs 1 or 2% of the rows to be modified/added/deleted before it will affect the execution plans adversely...

    larger tables need to have their stats updated manually a lot more often than the default auto stats will perform.

    manually update your stats on all your tables, and see if there is an instant performance gain.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 15, 2010 at 12:07 pm

    #1193686

    I would recommend concentrating on the first eight tables listed in the stored procedure proc_UpdateStatistics.

    The proper maxdop setting depends on a number of variables. Experiment!

    Dan

  • July 15, 2010 at 12:51 pm

    #1193718

    Hi

    CXPacket waits are an outcome of SQL Server deciding to use parallel queries.

    IF MAXDOP =0 and if the SQL server thinks that the Cost of the query is greater than the specified Cost Threshold for Parallelism value, then it uses parallel queries.

    To eliminate these waits and blocking disable the parallelism by selecting MAXDOP =1 in the server settings. OR increase the value for Cost Threshold for Parallelism.

    Grant "Lock Pages in Memory" privilege to SQL Server engine account if not already done. This will prevent SQL Server pages from being Paged out from the memory.

    Also try to create a maintenance plan or job to rebuild indexes weekly for the indexes with Fragmentation level > 30% and update the statistics using a job more frequently (daily or once in x-hours) based on the server OLTP activity.

    Thank You,

    Best Regards,

    SQLBuddy

  • July 15, 2010 at 2:52 pm

    #1193784

    I have Updated stats for the Content database to see whether it's reduces the blocking and noticed that only the below 10 tables required to update stats

    1. AllDocs

    2. AllDocStreams

    3.GroupMembership

    4. AllDocVersions

    5. AllLinks

    6. RecycleBin

    7. EventCache

    8. EventLog

    9. AllUserData

    10. UserInfo

    Use WSS_Content_Mydb

    go

    Sp_updatestats

    Results:

    Updating [dbo].[Deps]

    [Deps_DocToDep], update is not necessary...

    [Deps_DepToDoc], update is not necessary...

    [_WA_Sys_00000002_00551192], update is not necessary...

    [_WA_Sys_00000003_00551192], update is not necessary...

    [_WA_Sys_00000004_00551192], update is not necessary...

    [_WA_Sys_00000005_00551192], update is not necessary...

    [_WA_Sys_00000006_00551192], update is not necessary...

    0 index(es)/statistic(s) have been updated, 7 did not require update.

    Updating [dbo].[NameValuePair_German_PhoneBook_CI_AS]

    [NameValuePair_German_PhoneBook_CI_AS_CI], update is not necessary...

    [NameValuePair_German_PhoneBook_CI_AS_NoListId], update is not necessary...

    [NameValuePair_German_PhoneBook_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_01142BA1], update is not necessary...

    [_WA_Sys_00000004_01142BA1], update is not necessary...

    [_WA_Sys_00000005_01142BA1], update is not necessary...

    [_WA_Sys_00000002_01142BA1], update is not necessary...

    [_WA_Sys_00000006_01142BA1], update is not necessary...

    [_WA_Sys_00000007_01142BA1], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[GroupMembership]

    [GroupMembership_GroupId] has been updated...

    [GroupMembership_MemberId] has been updated...

    [_WA_Sys_00000003_02C769E9] has been updated...

    [_WA_Sys_00000002_02C769E9] has been updated...

    4 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Greek_CI_AS]

    [NameValuePair_Greek_CI_AS_CI], update is not necessary...

    [NameValuePair_Greek_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Greek_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_02FC7413], update is not necessary...

    [_WA_Sys_00000004_02FC7413], update is not necessary...

    [_WA_Sys_00000005_02FC7413], update is not necessary...

    [_WA_Sys_00000002_02FC7413], update is not necessary...

    [_WA_Sys_00000006_02FC7413], update is not necessary...

    [_WA_Sys_00000007_02FC7413], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[AllDocs]

    [AllDocs_PK] has been updated...

    [Docs_IdLevelUnique] has been updated...

    [_WA_Sys_00000003_03317E3D] has been updated...

    [_WA_Sys_00000004_03317E3D] has been updated...

    [_WA_Sys_00000005_03317E3D] has been updated...

    [_WA_Sys_00000008_03317E3D] has been updated...

    [_WA_Sys_00000019_03317E3D] has been updated...

    [_WA_Sys_0000002B_03317E3D] has been updated...

    [_WA_Sys_0000002C_03317E3D] has been updated...

    [_WA_Sys_00000010_03317E3D] has been updated...

    [_WA_Sys_0000001D_03317E3D] has been updated...

    [_WA_Sys_00000021_03317E3D] has been updated...

    [_WA_Sys_00000030_03317E3D] has been updated...

    [_WA_Sys_00000006_03317E3D] has been updated...

    [_WA_Sys_0000001F_03317E3D] has been updated...

    [_WA_Sys_00000007_03317E3D] has been updated...

    [_WA_Sys_00000034_03317E3D] has been updated...

    [_WA_Sys_00000035_03317E3D] has been updated...

    [_WA_Sys_0000001B_03317E3D] has been updated...

    [_WA_Sys_00000033_03317E3D] has been updated...

    [_WA_Sys_00000011_03317E3D] has been updated...

    [_WA_Sys_00000032_03317E3D] has been updated...

    [_WA_Sys_0000000C_03317E3D] has been updated...

    [_WA_Sys_0000000B_03317E3D] has been updated...

    [_WA_Sys_0000003B_03317E3D] has been updated...

    [_WA_Sys_0000001E_03317E3D] has been updated...

    [_WA_Sys_0000000F_03317E3D] has been updated...

    [_WA_Sys_0000000D_03317E3D] has been updated...

    [_WA_Sys_00000017_03317E3D] has been updated...

    [_WA_Sys_00000020_03317E3D] has been updated...

    [_WA_Sys_00000015_03317E3D] has been updated...

    [_WA_Sys_00000022_03317E3D] has been updated...

    [_WA_Sys_00000023_03317E3D] has been updated...

    [_WA_Sys_00000009_03317E3D] has been updated...

    34 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[Roles]

    [Roles_PK], update is not necessary...

    [Roles_Title], update is not necessary...

    [_WA_Sys_00000002_03BB8E22], update is not necessary...

    [_WA_Sys_00000003_03BB8E22], update is not necessary...

    0 index(es)/statistic(s) have been updated, 4 did not require update.

    Updating [dbo].[NameValuePair_Hebrew_CI_AS]

    [NameValuePair_Hebrew_CI_AS_CI], update is not necessary...

    [NameValuePair_Hebrew_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Hebrew_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_04E4BC85], update is not necessary...

    [_WA_Sys_00000004_04E4BC85], update is not necessary...

    [_WA_Sys_00000005_04E4BC85], update is not necessary...

    [_WA_Sys_00000002_04E4BC85], update is not necessary...

    [_WA_Sys_00000006_04E4BC85], update is not necessary...

    [_WA_Sys_00000007_04E4BC85], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Hindi_CI_AS]

    [NameValuePair_Hindi_CI_AS_CI], update is not necessary...

    [NameValuePair_Hindi_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Hindi_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_06CD04F7], update is not necessary...

    [_WA_Sys_00000004_06CD04F7], update is not necessary...

    [_WA_Sys_00000005_06CD04F7], update is not necessary...

    [_WA_Sys_00000002_06CD04F7], update is not necessary...

    [_WA_Sys_00000006_06CD04F7], update is not necessary...

    [_WA_Sys_00000007_06CD04F7], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[RoleAssignment]

    [RoleAssignment_PricipalId], update is not necessary...

    [_WA_Sys_00000002_078C1F06], update is not necessary...

    [_WA_Sys_00000003_078C1F06], update is not necessary...

    [_WA_Sys_00000004_078C1F06], update is not necessary...

    0 index(es)/statistic(s) have been updated, 4 did not require update.

    Updating [dbo].[NameValuePair_Hungarian_CI_AS]

    [NameValuePair_Hungarian_CI_AS_CI], update is not necessary...

    [NameValuePair_Hungarian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Hungarian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_08B54D69], update is not necessary...

    [_WA_Sys_00000004_08B54D69], update is not necessary...

    [_WA_Sys_00000005_08B54D69], update is not necessary...

    [_WA_Sys_00000002_08B54D69], update is not necessary...

    [_WA_Sys_00000006_08B54D69], update is not necessary...

    [_WA_Sys_00000007_08B54D69], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Hungarian_Technical_CI_AS]

    [NameValuePair_Hungarian_Technical_CI_AS_CI], update is not necessary...

    [NameValuePair_Hungarian_Technical_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Hungarian_Technical_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_0A9D95DB], update is not necessary...

    [_WA_Sys_00000004_0A9D95DB], update is not necessary...

    [_WA_Sys_00000005_0A9D95DB], update is not necessary...

    [_WA_Sys_00000002_0A9D95DB], update is not necessary...

    [_WA_Sys_00000006_0A9D95DB], update is not necessary...

    [_WA_Sys_00000007_0A9D95DB], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Icelandic_CI_AS]

    [NameValuePair_Icelandic_CI_AS_CI], update is not necessary...

    [NameValuePair_Icelandic_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Icelandic_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_0C85DE4D], update is not necessary...

    [_WA_Sys_00000004_0C85DE4D], update is not necessary...

    [_WA_Sys_00000005_0C85DE4D], update is not necessary...

    [_WA_Sys_00000002_0C85DE4D], update is not necessary...

    [_WA_Sys_00000006_0C85DE4D], update is not necessary...

    [_WA_Sys_00000007_0C85DE4D], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Japanese_CI_AS]

    [NameValuePair_Japanese_CI_AS_CI], update is not necessary...

    [NameValuePair_Japanese_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Japanese_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_0E6E26BF], update is not necessary...

    [_WA_Sys_00000004_0E6E26BF], update is not necessary...

    [_WA_Sys_00000005_0E6E26BF], update is not necessary...

    [_WA_Sys_00000002_0E6E26BF], update is not necessary...

    [_WA_Sys_00000006_0E6E26BF], update is not necessary...

    [_WA_Sys_00000007_0E6E26BF], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Japanese_Unicode_CI_AS]

    [NameValuePair_Japanese_Unicode_CI_AS_CI], update is not necessary...

    [NameValuePair_Japanese_Unicode_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Japanese_Unicode_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_10566F31], update is not necessary...

    [_WA_Sys_00000004_10566F31], update is not necessary...

    [_WA_Sys_00000005_10566F31], update is not necessary...

    [_WA_Sys_00000002_10566F31], update is not necessary...

    [_WA_Sys_00000006_10566F31], update is not necessary...

    [_WA_Sys_00000007_10566F31], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[AllDocStreams]

    [AllDocStreams_CK] has been updated...

    [AllDocStreams_DeleteTransactionIdIdLevelUnique] has been updated...

    [AllDocStreams_IdLevelUnique] has been updated...

    [AllDocStreams_SiteIdId] has been updated...

    [_WA_Sys_00000004_108B795B] has been updated...

    [_WA_Sys_00000006_108B795B] has been updated...

    6 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Korean_Wansung_CI_AS]

    [NameValuePair_Korean_Wansung_CI_AS_CI], update is not necessary...

    [NameValuePair_Korean_Wansung_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Korean_Wansung_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_123EB7A3], update is not necessary...

    [_WA_Sys_00000004_123EB7A3], update is not necessary...

    [_WA_Sys_00000005_123EB7A3], update is not necessary...

    [_WA_Sys_00000002_123EB7A3], update is not necessary...

    [_WA_Sys_00000006_123EB7A3], update is not necessary...

    [_WA_Sys_00000007_123EB7A3], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS]

    [NameValuePair_Korean_Wansung_Unicode_CI_AS_CI], update is not necessary...

    [NameValuePair_Korean_Wansung_Unicode_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Korean_Wansung_Unicode_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_14270015], update is not necessary...

    [_WA_Sys_00000004_14270015], update is not necessary...

    [_WA_Sys_00000005_14270015], update is not necessary...

    [_WA_Sys_00000002_14270015], update is not necessary...

    [_WA_Sys_00000006_14270015], update is not necessary...

    [_WA_Sys_00000007_14270015], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Latin1_General_CI_AS]

    [NameValuePair_Latin1_General_CI_AS_CI], update is not necessary...

    [NameValuePair_Latin1_General_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Latin1_General_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_160F4887], update is not necessary...

    [_WA_Sys_00000004_160F4887], update is not necessary...

    [_WA_Sys_00000005_160F4887], update is not necessary...

    [_WA_Sys_00000002_160F4887], update is not necessary...

    [_WA_Sys_00000006_160F4887], update is not necessary...

    [_WA_Sys_00000007_160F4887], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Latvian_CI_AS]

    [NameValuePair_Latvian_CI_AS_CI], update is not necessary...

    [NameValuePair_Latvian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Latvian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_17F790F9], update is not necessary...

    [_WA_Sys_00000004_17F790F9], update is not necessary...

    [_WA_Sys_00000005_17F790F9], update is not necessary...

    [_WA_Sys_00000002_17F790F9], update is not necessary...

    [_WA_Sys_00000006_17F790F9], update is not necessary...

    [_WA_Sys_00000007_17F790F9], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[AllDocVersions]

    [AllDocVersions_PK] has been updated...

    [_WA_Sys_00000002_182C9B23] has been updated...

    [_WA_Sys_00000003_182C9B23] has been updated...

    [_WA_Sys_0000000D_182C9B23] has been updated...

    [_WA_Sys_0000000B_182C9B23] has been updated...

    [_WA_Sys_0000000C_182C9B23] has been updated...

    [_WA_Sys_00000004_182C9B23] has been updated...

    [_WA_Sys_00000005_182C9B23] has been updated...

    [_WA_Sys_0000000E_182C9B23] has been updated...

    [_WA_Sys_0000000F_182C9B23] has been updated...

    10 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Lithuanian_CI_AS]

    [NameValuePair_Lithuanian_CI_AS_CI], update is not necessary...

    [NameValuePair_Lithuanian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Lithuanian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_19DFD96B], update is not necessary...

    [_WA_Sys_00000004_19DFD96B], update is not necessary...

    [_WA_Sys_00000005_19DFD96B], update is not necessary...

    [_WA_Sys_00000002_19DFD96B], update is not necessary...

    [_WA_Sys_00000006_19DFD96B], update is not necessary...

    [_WA_Sys_00000007_19DFD96B], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Lithuanian_Classic_CI_AS]

    [NameValuePair_Lithuanian_Classic_CI_AS_CI], update is not necessary...

    [NameValuePair_Lithuanian_Classic_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Lithuanian_Classic_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_1BC821DD], update is not necessary...

    [_WA_Sys_00000004_1BC821DD], update is not necessary...

    [_WA_Sys_00000005_1BC821DD], update is not necessary...

    [_WA_Sys_00000002_1BC821DD], update is not necessary...

    [_WA_Sys_00000006_1BC821DD], update is not necessary...

    [_WA_Sys_00000007_1BC821DD], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[AllLinks]

    [Links_Forward] has been updated...

    [Links_Backward] has been updated...

    [_WA_Sys_00000002_1CF15040] has been updated...

    [_WA_Sys_00000003_1CF15040] has been updated...

    [_WA_Sys_00000004_1CF15040] has been updated...

    [_WA_Sys_00000005_1CF15040] has been updated...

    [_WA_Sys_0000000F_1CF15040] has been updated...

    [_WA_Sys_00000008_1CF15040] has been updated...

    [_WA_Sys_0000000E_1CF15040] has been updated...

    [_WA_Sys_00000009_1CF15040] has been updated...

    [_WA_Sys_0000000D_1CF15040] has been updated...

    [_WA_Sys_0000000A_1CF15040] has been updated...

    [_WA_Sys_00000006_1CF15040] has been updated...

    [_WA_Sys_0000000B_1CF15040] has been updated...

    [_WA_Sys_0000000C_1CF15040] has been updated...

    [_WA_Sys_00000007_1CF15040] has been updated...

    16 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Traditional_Spanish_CI_AS]

    [NameValuePair_Traditional_Spanish_CI_AS_CI], update is not necessary...

    [NameValuePair_Traditional_Spanish_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Traditional_Spanish_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_1DB06A4F], update is not necessary...

    [_WA_Sys_00000004_1DB06A4F], update is not necessary...

    [_WA_Sys_00000005_1DB06A4F], update is not necessary...

    [_WA_Sys_00000002_1DB06A4F], update is not necessary...

    [_WA_Sys_00000006_1DB06A4F], update is not necessary...

    [_WA_Sys_00000007_1DB06A4F], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Modern_Spanish_CI_AS]

    [NameValuePair_Modern_Spanish_CI_AS_CI], update is not necessary...

    [NameValuePair_Modern_Spanish_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Modern_Spanish_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_1F98B2C1], update is not necessary...

    [_WA_Sys_00000004_1F98B2C1], update is not necessary...

    [_WA_Sys_00000005_1F98B2C1], update is not necessary...

    [_WA_Sys_00000002_1F98B2C1], update is not necessary...

    [_WA_Sys_00000006_1F98B2C1], update is not necessary...

    [_WA_Sys_00000007_1F98B2C1], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Polish_CI_AS]

    [NameValuePair_Polish_CI_AS_CI], update is not necessary...

    [NameValuePair_Polish_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Polish_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_2180FB33], update is not necessary...

    [_WA_Sys_00000004_2180FB33], update is not necessary...

    [_WA_Sys_00000005_2180FB33], update is not necessary...

    [_WA_Sys_00000002_2180FB33], update is not necessary...

    [_WA_Sys_00000006_2180FB33], update is not necessary...

    [_WA_Sys_00000007_2180FB33], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NavNodes]

    [NavNodes_PK], update is not necessary...

    [NavNodes_AltPK], update is not necessary...

    [NavNodes_DocId], update is not necessary...

    [_WA_Sys_00000002_21B6055D], update is not necessary...

    [_WA_Sys_00000003_21B6055D], update is not necessary...

    [_WA_Sys_00000004_21B6055D], update is not necessary...

    [_WA_Sys_00000006_21B6055D], update is not necessary...

    0 index(es)/statistic(s) have been updated, 7 did not require update.

    Updating [dbo].[RecycleBin]

    [RecycleBin_PK] has been updated...

    [RecycleBin_TransactionId] has been updated...

    [RecycleBin_ListTransactionId] has been updated...

    [_WA_Sys_00000002_22AA2996] has been updated...

    [_WA_Sys_00000003_22AA2996] has been updated...

    [_WA_Sys_00000009_22AA2996] has been updated...

    [_WA_Sys_00000004_22AA2996] has been updated...

    [_WA_Sys_00000006_22AA2996] has been updated...

    [_WA_Sys_00000007_22AA2996] has been updated...

    [_WA_Sys_0000000F_22AA2996] has been updated...

    [_WA_Sys_0000000B_22AA2996] has been updated...

    11 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Romanian_CI_AS]

    [NameValuePair_Romanian_CI_AS_CI], update is not necessary...

    [NameValuePair_Romanian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Romanian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_236943A5], update is not necessary...

    [_WA_Sys_00000004_236943A5], update is not necessary...

    [_WA_Sys_00000005_236943A5], update is not necessary...

    [_WA_Sys_00000002_236943A5], update is not necessary...

    [_WA_Sys_00000006_236943A5], update is not necessary...

    [_WA_Sys_00000007_236943A5], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[Sites]

    [Sites_Id], update is not necessary...

    [_WA_Sys_00000010_24927208] has been updated...

    1 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[NameValuePair_Slovak_CI_AS]

    [NameValuePair_Slovak_CI_AS_CI], update is not necessary...

    [NameValuePair_Slovak_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Slovak_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_25518C17], update is not necessary...

    [_WA_Sys_00000004_25518C17], update is not necessary...

    [_WA_Sys_00000005_25518C17], update is not necessary...

    [_WA_Sys_00000002_25518C17], update is not necessary...

    [_WA_Sys_00000006_25518C17], update is not necessary...

    [_WA_Sys_00000007_25518C17], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Slovenian_CI_AS]

    [NameValuePair_Slovenian_CI_AS_CI], update is not necessary...

    [NameValuePair_Slovenian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Slovenian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_2739D489], update is not necessary...

    [_WA_Sys_00000004_2739D489], update is not necessary...

    [_WA_Sys_00000005_2739D489], update is not necessary...

    [_WA_Sys_00000002_2739D489], update is not necessary...

    [_WA_Sys_00000006_2739D489], update is not necessary...

    [_WA_Sys_00000007_2739D489], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Thai_CI_AS]

    [NameValuePair_Thai_CI_AS_CI], update is not necessary...

    [NameValuePair_Thai_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Thai_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_29221CFB], update is not necessary...

    [_WA_Sys_00000004_29221CFB], update is not necessary...

    [_WA_Sys_00000005_29221CFB], update is not necessary...

    [_WA_Sys_00000002_29221CFB], update is not necessary...

    [_WA_Sys_00000006_29221CFB], update is not necessary...

    [_WA_Sys_00000007_29221CFB], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Turkish_CI_AS]

    [NameValuePair_Turkish_CI_AS_CI], update is not necessary...

    [NameValuePair_Turkish_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Turkish_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_2B0A656D], update is not necessary...

    [_WA_Sys_00000004_2B0A656D], update is not necessary...

    [_WA_Sys_00000005_2B0A656D], update is not necessary...

    [_WA_Sys_00000002_2B0A656D], update is not necessary...

    [_WA_Sys_00000006_2B0A656D], update is not necessary...

    [_WA_Sys_00000007_2B0A656D], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Ukrainian_CI_AS]

    [NameValuePair_Ukrainian_CI_AS_CI], update is not necessary...

    [NameValuePair_Ukrainian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Ukrainian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_2CF2ADDF], update is not necessary...

    [_WA_Sys_00000004_2CF2ADDF], update is not necessary...

    [_WA_Sys_00000005_2CF2ADDF], update is not necessary...

    [_WA_Sys_00000002_2CF2ADDF], update is not necessary...

    [_WA_Sys_00000006_2CF2ADDF], update is not necessary...

    [_WA_Sys_00000007_2CF2ADDF], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Vietnamese_CI_AS]

    [NameValuePair_Vietnamese_CI_AS_CI], update is not necessary...

    [NameValuePair_Vietnamese_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Vietnamese_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_2EDAF651], update is not necessary...

    [_WA_Sys_00000004_2EDAF651], update is not necessary...

    [_WA_Sys_00000005_2EDAF651], update is not necessary...

    [_WA_Sys_00000002_2EDAF651], update is not necessary...

    [_WA_Sys_00000006_2EDAF651], update is not necessary...

    [_WA_Sys_00000007_2EDAF651], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[WebParts]

    [PageUrlID_FK], update is not necessary...

    [ListId_FK], update is not necessary...

    [WebParts_PK], update is not necessary...

    [WebParts_UserID], update is not necessary...

    [_WA_Sys_00000009_30C33EC3], update is not necessary...

    [_WA_Sys_00000002_30C33EC3], update is not necessary...

    [_WA_Sys_00000017_30C33EC3], update is not necessary...

    [_WA_Sys_00000004_30C33EC3], update is not necessary...

    [_WA_Sys_00000005_30C33EC3], update is not necessary...

    [_WA_Sys_00000013_30C33EC3], update is not necessary...

    [_WA_Sys_0000000B_30C33EC3], update is not necessary...

    [_WA_Sys_0000000F_30C33EC3], update is not necessary...

    [_WA_Sys_00000018_30C33EC3], update is not necessary...

    [_WA_Sys_0000001A_30C33EC3], update is not necessary...

    0 index(es)/statistic(s) have been updated, 14 did not require update.

    Updating [dbo].[SiteVersions]

    [SiteVersions_PK], update is not necessary...

    [_WA_Sys_00000002_36B12243], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[Webs]

    [Webs_PK], update is not necessary...

    [Webs_SiteIdParent], update is not necessary...

    [Webs_FUAWI], update is not necessary...

    [Webs_MU], update is not necessary...

    [Webs_CMU], update is not necessary...

    [Webs_NPWI], update is not necessary...

    [_WA_Sys_00000024_38996AB5], update is not necessary...

    [_WA_Sys_00000011_38996AB5], update is not necessary...

    [_WA_Sys_00000004_38996AB5], update is not necessary...

    [_WA_Sys_00000014_38996AB5], update is not necessary...

    [_WA_Sys_00000003_38996AB5], update is not necessary...

    [_WA_Sys_00000023_38996AB5], update is not necessary...

    [_WA_Sys_0000002A_38996AB5], update is not necessary...

    [_WA_Sys_0000002B_38996AB5], update is not necessary...

    [_WA_Sys_00000009_38996AB5], update is not necessary...

    [_WA_Sys_0000002C_38996AB5] has been updated...

    [_WA_Sys_0000002D_38996AB5], update is not necessary...

    [_WA_Sys_0000001F_38996AB5] has been updated...

    [_WA_Sys_00000021_38996AB5], update is not necessary...

    2 index(es)/statistic(s) have been updated, 17 did not require update.

    Updating [dbo].[WebPartLists]

    [WebPartLists_PageUrlID], update is not necessary...

    [WebPartLists_ListId], update is not necessary...

    [_WA_Sys_00000004_395884C4], update is not necessary...

    [_WA_Sys_00000005_395884C4], update is not necessary...

    [_WA_Sys_00000007_395884C4], update is not necessary...

    [_WA_Sys_00000006_395884C4], update is not necessary...

    [_WA_Sys_00000003_395884C4], update is not necessary...

    0 index(es)/statistic(s) have been updated, 7 did not require update.

    Updating [dbo].[Features]

    [Features_PK], update is not necessary...

    [_WA_Sys_00000002_3B40CD36], update is not necessary...

    [_WA_Sys_00000003_3B40CD36], update is not necessary...

    0 index(es)/statistic(s) have been updated, 3 did not require update.

    Updating [dbo].[EventBatches]

    0 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[EventCache]

    [EventCache_Id] has been updated...

    [EventCache_Time] has been updated...

    [EventCache_SiteId] has been updated...

    [EventCache_ListId] has been updated...

    [_WA_Sys_0000000E_3F115E1A] has been updated...

    [_WA_Sys_0000000F_3F115E1A] has been updated...

    [_WA_Sys_00000004_3F115E1A] has been updated...

    [_WA_Sys_00000006_3F115E1A] has been updated...

    [_WA_Sys_00000007_3F115E1A] has been updated...

    [_WA_Sys_00000008_3F115E1A] has been updated...

    [_WA_Sys_00000009_3F115E1A] has been updated...

    [_WA_Sys_0000000A_3F115E1A] has been updated...

    [_WA_Sys_0000000B_3F115E1A] has been updated...

    [_WA_Sys_0000000D_3F115E1A] has been updated...

    [_WA_Sys_00000011_3F115E1A] has been updated...

    15 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[EventLog]

    [EventLog_Id] has been updated...

    [EventLog_SiteIdEventTime] has been updated...

    [_WA_Sys_00000003_40058253] has been updated...

    3 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[EventSubsMatches]

    [EventSubsMatches_EventIdSubId], update is not necessary...

    [_WA_Sys_00000002_40F9A68C], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[ImmedSubscriptions]

    [ImmedSubscriptions_SiteIdListIdItemId], update is not necessary...

    [ImmedSubscriptions_SiteIdWebIdUserId], update is not necessary...

    [ImmedSubscriptions_SiteIdUserIdSubId], update is not necessary...

    [ImmedSubscriptions_SiteIdWebUrlListUrl], update is not necessary...

    [_WA_Sys_00000007_41EDCAC5], update is not necessary...

    [_WA_Sys_00000003_41EDCAC5], update is not necessary...

    [_WA_Sys_00000004_41EDCAC5], update is not necessary...

    [_WA_Sys_00000005_41EDCAC5], update is not necessary...

    [_WA_Sys_00000001_41EDCAC5], update is not necessary...

    [_WA_Sys_00000006_41EDCAC5], update is not necessary...

    [_WA_Sys_00000017_41EDCAC5], update is not necessary...

    [_WA_Sys_0000001C_41EDCAC5], update is not necessary...

    [_WA_Sys_0000001E_41EDCAC5], update is not necessary...

    [_WA_Sys_0000001D_41EDCAC5], update is not necessary...

    0 index(es)/statistic(s) have been updated, 14 did not require update.

    Updating [dbo].[Categories]

    [Categories_DocId], update is not necessary...

    [Categories_CategoryId], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[WebCat]

    [WebCat_WebIdCategory], update is not necessary...

    [_WA_Sys_00000003_4316F928], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[AllLists]

    [AllLists_PK], update is not necessary...

    [Lists_FullText], update is not necessary...

    [_WA_Sys_0000001E_440B1D61], update is not necessary...

    [_WA_Sys_0000001F_440B1D61], update is not necessary...

    [_WA_Sys_0000000B_440B1D61], update is not necessary...

    [_WA_Sys_0000000E_440B1D61], update is not necessary...

    [_WA_Sys_0000000C_440B1D61], update is not necessary...

    [_WA_Sys_0000000D_440B1D61], update is not necessary...

    [_WA_Sys_00000003_440B1D61], update is not necessary...

    [_WA_Sys_0000000F_440B1D61], update is not necessary...

    [_WA_Sys_00000020_440B1D61], update is not necessary...

    [_WA_Sys_00000015_440B1D61], update is not necessary...

    [_WA_Sys_00000009_440B1D61], update is not necessary...

    0 index(es)/statistic(s) have been updated, 13 did not require update.

    Updating [dbo].[SchedSubscriptions]

    [SchedSubscriptions_SiteIdNotifyFreqListIdItemId], update is not necessary...

    [SchedSubscriptions_SiteIdWebIdUserId], update is not necessary...

    [SchedSubscriptions_SiteIdUserIdSubId], update is not necessary...

    [SchedSubscriptions_SiteIdWebUrlListUrl], update is not necessary...

    [SchedSubscriptions_NotifyTimeUTC], update is not necessary...

    [_WA_Sys_0000000A_46B27FE2], update is not necessary...

    [_WA_Sys_00000006_46B27FE2], update is not necessary...

    [_WA_Sys_00000007_46B27FE2], update is not necessary...

    [_WA_Sys_00000008_46B27FE2], update is not necessary...

    [_WA_Sys_00000001_46B27FE2], update is not necessary...

    [_WA_Sys_00000009_46B27FE2], update is not necessary...

    [_WA_Sys_0000001A_46B27FE2], update is not necessary...

    [_WA_Sys_0000001F_46B27FE2], update is not necessary...

    [_WA_Sys_00000021_46B27FE2], update is not necessary...

    [_WA_Sys_00000003_46B27FE2], update is not necessary...

    [_WA_Sys_00000020_46B27FE2], update is not necessary...

    0 index(es)/statistic(s) have been updated, 16 did not require update.

    Updating [dbo].[HT_Settings]

    [HT_Setting_PK], update is not necessary...

    0 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[HT_Cache]

    [HT_Cache_PK], update is not necessary...

    0 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[Personalization]

    [Personalization_PK], update is not necessary...

    [Personalization_ZoneID], update is not necessary...

    [Personalization_UserID], update is not necessary...

    [_WA_Sys_00000002_4B7734FF], update is not necessary...

    [_WA_Sys_00000003_4B7734FF], update is not necessary...

    [_WA_Sys_00000006_4B7734FF], update is not necessary...

    [_WA_Sys_00000004_4B7734FF], update is not necessary...

    [_WA_Sys_0000000A_4B7734FF], update is not necessary...

    0 index(es)/statistic(s) have been updated, 8 did not require update.

    Updating [dbo].[WelcomeNames]

    [WelcomeNames_PK], update is not necessary...

    0 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[TimerLock]

    [TimerLock_PK], update is not necessary...

    [_WA_Sys_00000002_503BEA1C] has been updated...

    [_WA_Sys_00000003_503BEA1C] has been updated...

    2 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[AllUserData]

    [AllUserData_Url] has been updated...

    [AllUserData_PK] has been updated...

    [_WA_Sys_00000001_5165187F] has been updated...

    [_WA_Sys_0000001B_5165187F] has been updated...

    [_WA_Sys_000000BB_5165187F] has been updated...

    [_WA_Sys_000000BC_5165187F] has been updated...

    [_WA_Sys_000000BE_5165187F] has been updated...

    [_WA_Sys_00000004_5165187F] has been updated...

    [_WA_Sys_00000019_5165187F] has been updated...

    [_WA_Sys_0000001A_5165187F] has been updated...

    [_WA_Sys_0000000F_5165187F] has been updated...

    [_WA_Sys_00000010_5165187F] has been updated...

    [_WA_Sys_00000006_5165187F] has been updated...

    [_WA_Sys_00000007_5165187F] has been updated...

    [_WA_Sys_0000000E_5165187F] has been updated...

    [_WA_Sys_000000AC_5165187F] has been updated...

    [_WA_Sys_00000005_5165187F] has been updated...

    [_WA_Sys_0000001D_5165187F] has been updated...

    [_WA_Sys_00000086_5165187F] has been updated...

    [_WA_Sys_00000087_5165187F] has been updated...

    [_WA_Sys_00000088_5165187F] has been updated...

    [_WA_Sys_000000C0_5165187F] has been updated...

    [_WA_Sys_000000C1_5165187F] has been updated...

    [_WA_Sys_0000000C_5165187F] has been updated...

    [_WA_Sys_000000AA_5165187F] has been updated...

    [_WA_Sys_000000BD_5165187F] has been updated...

    [_WA_Sys_00000020_5165187F] has been updated...

    [_WA_Sys_00000023_5165187F] has been updated...

    [_WA_Sys_00000024_5165187F] has been updated...

    [_WA_Sys_00000033_5165187F] has been updated...

    [_WA_Sys_000000AB_5165187F] has been updated...

    [_WA_Sys_000000AD_5165187F] has been updated...

    [_WA_Sys_0000001C_5165187F] has been updated...

    [_WA_Sys_00000008_5165187F] has been updated...

    [_WA_Sys_0000001E_5165187F] has been updated...

    [_WA_Sys_00000021_5165187F] has been updated...

    [_WA_Sys_000000A2_5165187F] has been updated...

    [_WA_Sys_00000030_5165187F] has been updated...

    [_WA_Sys_00000025_5165187F] has been updated...

    [_WA_Sys_000000A3_5165187F] has been updated...

    [_WA_Sys_000000A4_5165187F] has been updated...

    [_WA_Sys_0000002D_5165187F] has been updated...

    [_WA_Sys_0000001F_5165187F] has been updated...

    [_WA_Sys_00000096_5165187F] has been updated...

    [_WA_Sys_0000002C_5165187F] has been updated...

    [_WA_Sys_0000000D_5165187F] has been updated...

    [_WA_Sys_0000002B_5165187F] has been updated...

    [_WA_Sys_0000002F_5165187F] has been updated...

    [_WA_Sys_0000002E_5165187F] has been updated...

    [_WA_Sys_00000031_5165187F] has been updated...

    50 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[DiskWarningDate]

    0 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[Workflow]

    [Workflow_PK], update is not necessary...

    [Workflow_IdUnique], update is not necessary...

    [Workflow_CreatedBy], update is not necessary...

    [Workflow_OnItem], update is not necessary...

    [Workflow_OnId], update is not necessary...

    [_WA_Sys_00000005_531856C7], update is not necessary...

    [_WA_Sys_0000000D_531856C7], update is not necessary...

    [_WA_Sys_00000002_531856C7], update is not necessary...

    [_WA_Sys_00000003_531856C7], update is not necessary...

    [_WA_Sys_00000008_531856C7], update is not necessary...

    [_WA_Sys_0000000B_531856C7], update is not necessary...

    0 index(es)/statistic(s) have been updated, 11 did not require update.

    Updating [dbo].[WorkflowAssociation]

    [WorkflowAssociation_Id], update is not necessary...

    [WorkflowAssociation_IdUnique], update is not necessary...

    [WorkflowAssociation_Parent], update is not necessary...

    [_WA_Sys_00000008_57DD0BE4], update is not necessary...

    [_WA_Sys_00000009_57DD0BE4], update is not necessary...

    [_WA_Sys_0000000A_57DD0BE4], update is not necessary...

    [_WA_Sys_00000011_57DD0BE4], update is not necessary...

    [_WA_Sys_00000012_57DD0BE4], update is not necessary...

    0 index(es)/statistic(s) have been updated, 8 did not require update.

    Updating [dbo].[ScheduledWorkItems]

    [ScheduledWorkItems_OnDateType], update is not necessary...

    [ScheduledWorkItems_IdUnique], update is not necessary...

    [ScheduledWorkItems_OnId], update is not necessary...

    [ScheduledWorkItems_OnListKey], update is not necessary...

    [_WA_Sys_00000005_5BAD9CC8], update is not necessary...

    [_WA_Sys_00000003_5BAD9CC8], update is not necessary...

    [_WA_Sys_00000008_5BAD9CC8], update is not necessary...

    [_WA_Sys_00000011_5BAD9CC8], update is not necessary...

    [_WA_Sys_0000000E_5BAD9CC8], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[ComMd]

    [ComMd_SiteIdDocIdId], update is not necessary...

    [_WA_Sys_00000002_5F7E2DAC], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[EventReceivers]

    [EventReceivers_ByTarget], update is not necessary...

    [EventReceivers_IdUnique], update is not necessary...

    [EventReceivers_ById], update is not necessary...

    [EventReceivers_ByContextObjectId], update is not necessary...

    [EventReceivers_ByContextCollectionId], update is not necessary...

    [_WA_Sys_00000004_6166761E], update is not necessary...

    [_WA_Sys_00000005_6166761E], update is not necessary...

    [_WA_Sys_00000006_6166761E], update is not necessary...

    [_WA_Sys_00000010_6166761E], update is not necessary...

    [_WA_Sys_00000011_6166761E], update is not necessary...

    [_WA_Sys_0000000A_6166761E], update is not necessary...

    [_WA_Sys_0000000C_6166761E], update is not necessary...

    [_WA_Sys_0000000D_6166761E], update is not necessary...

    [_WA_Sys_00000013_6166761E], update is not necessary...

    [_WA_Sys_00000014_6166761E], update is not necessary...

    [_WA_Sys_00000015_6166761E], update is not necessary...

    [_WA_Sys_00000016_6166761E], update is not necessary...

    [_WA_Sys_00000017_6166761E], update is not necessary...

    [_WA_Sys_0000000B_6166761E], update is not necessary...

    0 index(es)/statistic(s) have been updated, 19 did not require update.

    Updating [dbo].[NameValuePair]

    [NameValuePair_CI], update is not necessary...

    [NameValuePair_NoListId], update is not necessary...

    [NameValuePair_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_6477ECF3], update is not necessary...

    [_WA_Sys_00000004_6477ECF3], update is not necessary...

    [_WA_Sys_00000005_6477ECF3], update is not necessary...

    [_WA_Sys_00000006_6477ECF3], update is not necessary...

    [_WA_Sys_00000007_6477ECF3], update is not necessary...

    [_WA_Sys_00000002_6477ECF3], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[ContentTypes]

    [ContentType_PK], update is not necessary...

    [_WA_Sys_00000002_65370702], update is not necessary...

    [_WA_Sys_00000003_65370702], update is not necessary...

    [_WA_Sys_00000004_65370702], update is not necessary...

    [_WA_Sys_00000008_65370702], update is not necessary...

    0 index(es)/statistic(s) have been updated, 5 did not require update.

    Updating [dbo].[NameValuePair_Albanian_CI_AS]

    [NameValuePair_Albanian_CI_AS_CI], update is not necessary...

    [NameValuePair_Albanian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Albanian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_66603565], update is not necessary...

    [_WA_Sys_00000004_66603565], update is not necessary...

    [_WA_Sys_00000005_66603565], update is not necessary...

    [_WA_Sys_00000002_66603565], update is not necessary...

    [_WA_Sys_00000006_66603565], update is not necessary...

    [_WA_Sys_00000007_66603565], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Arabic_CI_AS]

    [NameValuePair_Arabic_CI_AS_CI], update is not necessary...

    [NameValuePair_Arabic_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Arabic_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_68487DD7], update is not necessary...

    [_WA_Sys_00000004_68487DD7], update is not necessary...

    [_WA_Sys_00000005_68487DD7], update is not necessary...

    [_WA_Sys_00000002_68487DD7], update is not necessary...

    [_WA_Sys_00000006_68487DD7], update is not necessary...

    [_WA_Sys_00000007_68487DD7], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[AuditData]

    [AuditData_OnSiteItem], update is not necessary...

    [_WA_Sys_0000000A_690797E6], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[SiteQuota]

    [SiteQuota_SiteId] has been updated...

    1 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Chinese_PRC_CI_AS]

    [NameValuePair_Chinese_PRC_CI_AS_CI], update is not necessary...

    [NameValuePair_Chinese_PRC_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Chinese_PRC_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_6A30C649], update is not necessary...

    [_WA_Sys_00000004_6A30C649], update is not necessary...

    [_WA_Sys_00000005_6A30C649], update is not necessary...

    [_WA_Sys_00000002_6A30C649], update is not necessary...

    [_WA_Sys_00000006_6A30C649], update is not necessary...

    [_WA_Sys_00000007_6A30C649], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[ContentTypeUsage]

    [pk_ContentTypeUsage], update is not necessary...

    [idx_ListOnContentTypeUsage], update is not necessary...

    [_WA_Sys_00000002_6AEFE058], update is not necessary...

    [_WA_Sys_00000003_6AEFE058], update is not necessary...

    [_WA_Sys_00000004_6AEFE058], update is not necessary...

    [_WA_Sys_00000005_6AEFE058], update is not necessary...

    [_WA_Sys_00000006_6AEFE058], update is not necessary...

    0 index(es)/statistic(s) have been updated, 7 did not require update.

    Updating [dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS]

    [NameValuePair_Chinese_PRC_Stroke_CI_AS_CI], update is not necessary...

    [NameValuePair_Chinese_PRC_Stroke_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Chinese_PRC_Stroke_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_6C190EBB], update is not necessary...

    [_WA_Sys_00000004_6C190EBB], update is not necessary...

    [_WA_Sys_00000005_6C190EBB], update is not necessary...

    [_WA_Sys_00000002_6C190EBB], update is not necessary...

    [_WA_Sys_00000006_6C190EBB], update is not necessary...

    [_WA_Sys_00000007_6C190EBB], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS]

    [NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_CI], update is not necessary...

    [NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_6E01572D], update is not necessary...

    [_WA_Sys_00000004_6E01572D], update is not necessary...

    [_WA_Sys_00000005_6E01572D], update is not necessary...

    [_WA_Sys_00000002_6E01572D], update is not necessary...

    [_WA_Sys_00000006_6E01572D], update is not necessary...

    [_WA_Sys_00000007_6E01572D], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[BuildDependencies]

    [BuildDependencies_Forward], update is not necessary...

    [BuildDependencies_Backward], update is not necessary...

    [_WA_Sys_00000002_6EC0713C], update is not necessary...

    [_WA_Sys_00000003_6EC0713C], update is not necessary...

    [_WA_Sys_00000004_6EC0713C], update is not necessary...

    [_WA_Sys_00000005_6EC0713C], update is not necessary...

    0 index(es)/statistic(s) have been updated, 6 did not require update.

    Updating [dbo].[Image0x]

    0 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS]

    [NameValuePair_Chinese_Taiwan_Stroke_CI_AS_CI], update is not necessary...

    [NameValuePair_Chinese_Taiwan_Stroke_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Chinese_Taiwan_Stroke_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_6FE99F9F], update is not necessary...

    [_WA_Sys_00000004_6FE99F9F], update is not necessary...

    [_WA_Sys_00000005_6FE99F9F], update is not necessary...

    [_WA_Sys_00000002_6FE99F9F], update is not necessary...

    [_WA_Sys_00000006_6FE99F9F], update is not necessary...

    [_WA_Sys_00000007_6FE99F9F], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[CollationNames]

    [CollationNames_Collation], update is not necessary...

    0 index(es)/statistic(s) have been updated, 1 did not require update.

    Updating [dbo].[AllUserDataJunctions]

    [AllUserDataJunctions_PK], update is not necessary...

    [_WA_Sys_00000002_719CDDE7], update is not necessary...

    [_WA_Sys_00000003_719CDDE7], update is not necessary...

    [_WA_Sys_00000004_719CDDE7], update is not necessary...

    [_WA_Sys_00000005_719CDDE7], update is not necessary...

    [_WA_Sys_00000007_719CDDE7], update is not necessary...

    [_WA_Sys_00000008_719CDDE7], update is not necessary...

    [_WA_Sys_00000006_719CDDE7], update is not necessary...

    [_WA_Sys_0000000B_719CDDE7], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Croatian_CI_AS]

    [NameValuePair_Croatian_CI_AS_CI], update is not necessary...

    [NameValuePair_Croatian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Croatian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_71D1E811], update is not necessary...

    [_WA_Sys_00000004_71D1E811], update is not necessary...

    [_WA_Sys_00000005_71D1E811], update is not necessary...

    [_WA_Sys_00000002_71D1E811], update is not necessary...

    [_WA_Sys_00000006_71D1E811], update is not necessary...

    [_WA_Sys_00000007_71D1E811], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Cyrillic_General_CI_AS]

    [NameValuePair_Cyrillic_General_CI_AS_CI], update is not necessary...

    [NameValuePair_Cyrillic_General_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Cyrillic_General_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_73BA3083], update is not necessary...

    [_WA_Sys_00000004_73BA3083], update is not necessary...

    [_WA_Sys_00000005_73BA3083], update is not necessary...

    [_WA_Sys_00000002_73BA3083], update is not necessary...

    [_WA_Sys_00000006_73BA3083], update is not necessary...

    [_WA_Sys_00000007_73BA3083], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Czech_CI_AS]

    [NameValuePair_Czech_CI_AS_CI], update is not necessary...

    [NameValuePair_Czech_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Czech_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_75A278F5], update is not necessary...

    [_WA_Sys_00000004_75A278F5], update is not necessary...

    [_WA_Sys_00000005_75A278F5], update is not necessary...

    [_WA_Sys_00000002_75A278F5], update is not necessary...

    [_WA_Sys_00000006_75A278F5], update is not necessary...

    [_WA_Sys_00000007_75A278F5], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [sys].[queue_messages_1977058079]

    [queue_clustered_index], update is not necessary...

    [queue_secondary_index], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[UserInfo]

    [UserInfo_PK], update is not necessary...

    [UserInfo_SID], update is not necessary...

    [UserInfo_Login], update is not necessary...

    [UserInfo_Id], update is not necessary...

    [UserInfo_Email], update is not necessary...

    [UserInfo_SiteAdmin], update is not necessary...

    [_WA_Sys_00000002_7755B73D], update is not necessary...

    [_WA_Sys_00000006_7755B73D], update is not necessary...

    [_WA_Sys_00000005_7755B73D], update is not necessary...

    [_WA_Sys_00000003_7755B73D], update is not necessary...

    [_WA_Sys_00000009_7755B73D] has been updated...

    [_WA_Sys_0000000A_7755B73D] has been updated...

    [_WA_Sys_0000000B_7755B73D] has been updated...

    [_WA_Sys_00000007_7755B73D], update is not necessary...

    [_WA_Sys_0000000C_7755B73D], update is not necessary...

    3 index(es)/statistic(s) have been updated, 12 did not require update.

    Updating [dbo].[NameValuePair_Danish_Norwegian_CI_AS]

    [NameValuePair_Danish_Norwegian_CI_AS_CI], update is not necessary...

    [NameValuePair_Danish_Norwegian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Danish_Norwegian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_778AC167], update is not necessary...

    [_WA_Sys_00000004_778AC167], update is not necessary...

    [_WA_Sys_00000005_778AC167], update is not necessary...

    [_WA_Sys_00000002_778AC167], update is not necessary...

    [_WA_Sys_00000006_778AC167], update is not necessary...

    [_WA_Sys_00000007_778AC167], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [sys].[queue_messages_2009058193]

    [queue_clustered_index], update is not necessary...

    [queue_secondary_index], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[NameValuePair_Estonian_CI_AS]

    [NameValuePair_Estonian_CI_AS_CI], update is not necessary...

    [NameValuePair_Estonian_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Estonian_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_797309D9], update is not necessary...

    [_WA_Sys_00000004_797309D9], update is not necessary...

    [_WA_Sys_00000005_797309D9], update is not necessary...

    [_WA_Sys_00000002_797309D9], update is not necessary...

    [_WA_Sys_00000006_797309D9], update is not necessary...

    [_WA_Sys_00000007_797309D9], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [sys].[queue_messages_2041058307]

    [queue_clustered_index], update is not necessary...

    [queue_secondary_index], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[WebMembers]

    [WebMembers_PK] has been updated...

    [_WA_Sys_00000002_7B264821] has been updated...

    2 index(es)/statistic(s) have been updated, 0 did not require update.

    Updating [dbo].[NameValuePair_Finnish_Swedish_CI_AS]

    [NameValuePair_Finnish_Swedish_CI_AS_CI], update is not necessary...

    [NameValuePair_Finnish_Swedish_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Finnish_Swedish_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_7B5B524B], update is not necessary...

    [_WA_Sys_00000004_7B5B524B], update is not necessary...

    [_WA_Sys_00000005_7B5B524B], update is not necessary...

    [_WA_Sys_00000002_7B5B524B], update is not necessary...

    [_WA_Sys_00000006_7B5B524B], update is not necessary...

    [_WA_Sys_00000007_7B5B524B], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[Versions]

    [Versions_PK], update is not necessary...

    [_WA_Sys_00000002_7B905C75], update is not necessary...

    0 index(es)/statistic(s) have been updated, 2 did not require update.

    Updating [dbo].[Perms]

    [Perms_PK], update is not necessary...

    [Perms_WebId], update is not necessary...

    [Perms_Url], update is not necessary...

    [_WA_Sys_00000002_7D0E9093], update is not necessary...

    [_WA_Sys_00000004_7D0E9093], update is not necessary...

    [_WA_Sys_00000005_7D0E9093], update is not necessary...

    [_WA_Sys_00000006_7D0E9093], update is not necessary...

    [_WA_Sys_00000003_7D0E9093], update is not necessary...

    0 index(es)/statistic(s) have been updated, 8 did not require update.

    Updating [dbo].[NameValuePair_French_CI_AS]

    [NameValuePair_French_CI_AS_CI], update is not necessary...

    [NameValuePair_French_CI_AS_NoListId], update is not necessary...

    [NameValuePair_French_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_7D439ABD], update is not necessary...

    [_WA_Sys_00000004_7D439ABD], update is not necessary...

    [_WA_Sys_00000005_7D439ABD], update is not necessary...

    [_WA_Sys_00000002_7D439ABD], update is not necessary...

    [_WA_Sys_00000006_7D439ABD], update is not necessary...

    [_WA_Sys_00000007_7D439ABD], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS]

    [NameValuePair_Georgian_Modern_Sort_CI_AS_CI], update is not necessary...

    [NameValuePair_Georgian_Modern_Sort_CI_AS_NoListId], update is not necessary...

    [NameValuePair_Georgian_Modern_Sort_CI_AS_MatchUserData], update is not necessary...

    [_WA_Sys_00000003_7F2BE32F], update is not necessary...

    [_WA_Sys_00000004_7F2BE32F], update is not necessary...

    [_WA_Sys_00000005_7F2BE32F], update is not necessary...

    [_WA_Sys_00000002_7F2BE32F], update is not necessary...

    [_WA_Sys_00000006_7F2BE32F], update is not necessary...

    [_WA_Sys_00000007_7F2BE32F], update is not necessary...

    0 index(es)/statistic(s) have been updated, 9 did not require update.

    Updating [dbo].[Groups]

    [Groups_PK], update is not necessary...

    [Groups_Title], update is not necessary...

    [Groups_Id], update is not necessary...

    [Groups_DLAlias], update is not necessary...

    [_WA_Sys_00000003_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000005_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000006_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000002_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000007_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000004_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000008_7FEAFD3E], update is not necessary...

    [_WA_Sys_00000009_7FEAFD3E], update is not necessary...

    [_WA_Sys_0000000A_7FEAFD3E], update is not necessary...

    [_WA_Sys_0000000B_7FEAFD3E], update is not necessary...

    [_WA_Sys_0000000C_7FEAFD3E], update is not necessary...

    [_WA_Sys_0000000D_7FEAFD3E], update is not necessary...

    0 index(es)/statistic(s) have been updated, 16 did not require update.

    Statistics for all tables have been updated.

    But still the CXPACKET blocking is occurring continuously so it's looks like CXPACKET blocking is NOT related to Update stats..

    Please advice

    Thanks

  • July 15, 2010 at 6:13 pm

    #1193841

    How is the user experience now? You might want to run a trace just to verify that what SpotLight reports is really a valid concern.

    Reads, Duration and CPU for the queries you attached are real low on my system.

  • July 16, 2010 at 1:52 pm

    #1194341

    You might want to look into using RCSI (read committed snapshot isolation) on the Sharepoint database. It should significantly reduce the number of blocking processes.

  • July 16, 2010 at 1:59 pm

    #1194345

    I have my Sharepoint database server configured to only use

    EXEC sp_configure 'max degree of parallelism', 1

    GO

    RECONFIGURE

    GO

    EXEC sp_configure 'optimize for ad hoc workloads', 1

    go

    RECONFIGURE

    go

    This really has helped performance. You might also check to ensure you are not using Lightweight pooling. Also CXPACKET can indicate a CPU bottleneck so you might want to check your RAID configuration. My SP Db server is a RAID 1 + 0 for OS, RAID 5 for data, and RAID 1 + 0 for Logs AND I also put tempdb (heavily used in SP) on my RAID 1 + 0 with my logs.

    Hope this helps!

    Hawkeye DBA

  • July 16, 2010 at 4:44 pm

    #1194426

    Hi

    Optimize for ad hoc workloads is available only in SQL Server 2008.

    Thank You,

    Best Regards,

    SQLBuddy.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply