SharePoint 2013 Performance Report

Question

The performance of my SharePoint 2013 is horrible.The config is a very simple 2-server config (1x WFE/App & 1xSQL).

I am quite convinced the issue is SQL Server Performance, but to justify the spend I need to provide some metrics (not just gut feel).

Can anyone suggest a way I can gather metrics t prove what the bottleneck is?

Answer 1

Use Fiddler for benchmarking traffic on the browser side.

Use ULS Logs for benchmarking traffic in SharePoint.

Use SQL Profiler and Perfmon to benchmark traffic on the SharePoint and SQL Server.

---

I trust that answers your question...

Thanks
C
| RSS | http://crayveon.com/blog | SharePoint Scripts | Twitter | Google+ | LinkedIn | Facebook | Quix Utilities for SharePoint

Answer 2

You can also get good performance data from the Usage/Logging Database. There will be multiple timer jobs starting with the word Diagnostic...If you want to collect specific data in the Usage/Logging Database you can start these timer jobs and wait for about 24 hours. After 24 hours you take a look at this database and analyze performance for the SQL and SharePoint server(s). This is the ONLY database that Microsoft allows you to query and they actually have some pretty good built-in views for looking at this information. Source: http://technet.microsoft.com/en-us/library/cc678868(v=office.15).aspx

---

Regards,

Andrew J Billings

Portal Systems Engineer//MCSA,MCSE

Blog: http://www.andrewjbillings.com  Twitter:   LinkedIn: