none
SharePoint Performance is very slow. RRS feed

All replies

  • To figure out what is wrong you have to check up for errors:

    1. Application event log

    2. SharePoint log C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS

    3. MS SQL Log

    Post errors if you will find any.


    Oleg
    Thursday, December 30, 2010 4:14 PM
  • i checked Event viewer and i am finding this error :

    The description for Event ID ( 8214 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: A request was made for a URL, http://localhost:86, which has not been configured in Alternate Access Mappings. Some links may point to the Alternate Access URL for the default zone, http://nbciiscph012v:86. Review the Alternate Access mappings for this Web application at http://nbciiscph012v:34455/_admin/AlternateUrlCollections.aspx and consider adding http://localhost:86 as a Public Alternate Access URL if it will be used frequently. Help on this error:

    http://go.microsoft.com/fwlink/?LinkId=114854.

    Thanks


    Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator
    Thursday, December 30, 2010 4:18 PM
  • What about MS SQL logs and SharePoint logs? Check Security Event log too.


    Oleg
    Thursday, December 30, 2010 4:28 PM
  • Security Logs shows:

    User Logoff:

    User Name: nbc_moss_farm_1

    Domain: NOBELBIOCARE

    Logon ID: (0x1,0x851CBFCA)

    Logon Type: 4

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    SharePoint Logs says:

    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8 Windows SharePoint Services    Database                       7t61 Verbose  DatabaseConnectionString acquired.  Server=NBCVCNCPH001V1;Database=NBC_SSP1_Prod_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15 
    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8                                484                            880l Verbose  ConnectionString: 'Server=NBCVCNCPH001V1;Database=NBC_SSP1_Prod_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15 
    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8                                1624                           8acb Verbose  Reverting to process identity 
    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8                                1624                           8acc Verbose  Current user before SqlConnection.Open: Name: NOBELBIOCARE\nbc_moss_farm_1 SID: S-1-5-21-1370467521-2853904403-1986950576-61833 ImpersonationLevel: None 
    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8                                1624                           8acf Verbose  Current user after SqlConnection.Open: Name: NOBELBIOCARE\nbc_moss_farm_1 SID: S-1-5-21-1370467521-2853904403-1986950576-61833 ImpersonationLevel: None 
    12/30/2010 17:41:55.11  w3wp.exe (0x0F1C)                        0x03E8                                484                            880m Verbose  SqlCommand: 'dbo.proc_MIP_GetObjectUpdates'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@Version' Type: BigInt Size: 0 Direction: Input Value: '441'     Parameter: '@CurrentVersion' Type: BigInt Size: 0 Direction: Output Value: '' 

    I am not able to find SQL logs. Please let me know the exact location. Database server is a different server in my scnario. Thanks in advance.

     


    Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator
    Thursday, December 30, 2010 4:50 PM
  • You can open MS SQL log from SQL Server Management Studio. YOURSERVER->Management->SQL Server Logs
    Oleg
    Thursday, December 30, 2010 4:54 PM
  • it is not allowing me to execute the SQl logs. What to do?
    Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator
    Thursday, December 30, 2010 5:06 PM
  • Maybe make sense to ask DBA check what is wrong with SQL server?
    Oleg
    Thursday, December 30, 2010 5:12 PM
  • > it is not allowing me to execute the SQl logs. What to do?

    This kind of post is OK.

    A post from you (now deleted) to a very much alive thread saying less than a day after the previous post in the thread "Can Some body help me on this? Any ideas???" is NOT OK.

    If you must bump, do so after at the very earliest THREE WORK DAYS and give some extra information.

    In this case you did neither.

    Moderator pre-2010 forums.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, December 31, 2010 11:29 AM
  • This follow-up (Note: later deleted but said " it is fine. i understood but i am not getting any reply from anyone. So i just replied for someone to see it and reply accordingly.") shows that you still do not understand.

    These are forums. People will reply IF they want to and WHEN they want to.

    It is not your job to post messages demanding a reply to your questions as you did here.

    Certainly not only 18 hours after someone has posted in the thread. (and in this case a mere 20 hours after you started a thread which has already got a lot of replies)

    Next time, just remember that you are not the only person posting questions here and that your questions are no more important than anyone else's questions and do NOT bump your posts.

    If you are in that kind of a hurry you should not be using the forums for support. You should be signing a Premium Support contract with Microsoft or at least paying on a case-by-case basis for support by ringing Microsoft Customer Support Services.

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Edited by Mike Walsh FIN Friday, December 31, 2010 1:12 PM Bracketed note added.
    Friday, December 31, 2010 12:16 PM
  • Hi Oleg,

    I could get the SQL Error Logs. My content database name is WSS_Content_IntranetNew:

    2010-12-31 10:10:00.04 Backup      Log was backed up. Database: WSS_Content_IntranetNew, creation date(time): 2010/11/24(11:06:28), first LSN: 9345:2843:1, last LSN: 9345:9169:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'VNBU0-3548-4156-1293786569'}). This is an informational message only. No user action is required.

    2010-12-30 06:10:52.13 Backup      Log was backed up. Database: WSS_Content_Prod_SharedServices, creation date(time): 2010/08/12(16:49:21), first LSN: 2403:461:1, last LSN: 2420:490:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'VNBU0-5004-3676-1293685821'}). This is an informational message only. No user action is required.

    2010-12-30 06:09:57.80 Backup      Log was backed up. Database: WSS_Content_IntranetNew, creation date(time): 2010/11/24(11:06:28), first LSN: 9275:73:1, last LSN: 9321:1752:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'VNBU0-5004-6132-1293685764'}). This is an informational message only. No user action is required.


    Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator
    Friday, December 31, 2010 12:38 PM
  • Hi,

     

    According to your description, please recomend follow read article about best practices, Tune Web server performance (Office SharePoint Server):

    http://technet.microsoft.com/en-us/library/cc298550(office.12).aspx

    I hope it can help you a little.

    In addition, check your application pool setting.

     

    Best regards,

    David Hu

     

    Monday, January 3, 2011 2:15 AM
  • This is really good article too http://www.mssqltips.com/tip.asp?tip=1777
    Oleg
    Monday, January 3, 2011 3:02 PM
  • > This is really good article

    Maybe, but it's about content databases.

    Where in the article is the connection to performance ?


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, January 3, 2011 3:07 PM
  • Did you read this article? This is the practical guide how to keep SharePoint database performance on acceptable level. The previous post contains just theoretical information.
    Oleg
    Monday, January 3, 2011 4:24 PM
  • I scanned it quickly.

    I was expecting a paper on SharePoint performance. What I found was a paper with a lot of detail about content databases and with a Title that didn't mention performance at all.

    My quick scan didn't find a section head that included the word Performance so that was why I was asking you where in the article the Performance information was.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, January 3, 2011 5:33 PM