Tag-arkiv: performance

Enabling the SharePoint 2010 Developer Dashboard

  Although this tool is mainly designed to assist developers in creating fast code, it can also be a useful tool for the administrators by providing performance and trace information when troubleshooting slow loading/rendering pages. It can be enabled using … Læs resten

Udgivet i SharePoint 2010 Tips & Tricks | Tagget , , | Kommentarer lukket til Enabling the SharePoint 2010 Developer Dashboard

Drop Column statistics

Are you facing suddenly poor performance, try to recreate Columns statistics. SQL Server are using these statistics to decide which execution-plan would be the best. You always have to run this script when you are upgrading your SQL server from … Læs resten

Udgivet i SQL Server - scripts | Tagget , , | Kommentarer lukket til Drop Column statistics