We have a production server having 2 WFE's and one application server and an intranet site in MOSS 2007. When i am diagnosing the site with Fiddler it is showing me the following errors: 1. MINI CHART http://production.investis.com/nobelbiocare/mini_chart/-------------------------Error : 502 2. NBINTRANET Theme-------------------------------------------------------- Error : 401 3. http://intranet.nobelbiocare.net/_themes/NBINTRANET/bl_Shadow_Right.jpg--------- Error : 401 4. Page Layouts : http://intranet.nobelbiocare.net/Style%20Library/nb/pageLayouts.css---------- Error : 401 5. Site Collection Images: http://intranet.nobelbiocare.net/SiteCollectionImages/people/management/r_rauch.jpg---------- Error : 401 http://intranet.nobelbiocare.net/SiteCollectionImages/banners/kiwi.jpg ------ Error : 401 6. There is something called google analytics it is also showing error like this: http://www.google-analytics.com/ga.js---------------------------------------------Error : 502 Please suggest what could be the exact reason and what could be the optimum resolution for these isuues. The Home page loading itself is taking more than 1 minute and subsites are taking more time to load. Please suggest.Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator

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

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

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

it is not allowing me to execute the SQl logs. What to do?Thanks and Regards, Amreesh Sharma| MCTS MOSS 2007| SharePoint Administrator

Maybe make sense to ask DBA check what is wrong with SQL server?Oleg

> 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

> 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

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

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

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

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

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

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

This is really good article too http://www.mssqltips.com/tip.asp?tip=1777Oleg

> 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

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

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