StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>There are a number of things that can be affecting performance. There could be resource contention, sub-optimal SQL Server configuration, slow disks, missing indexes etc...</p> <p>I would start by monitoring the system resources when both processes are running. You can use perfmon to monitor the OS and SQL counters. I would start by looking at </p> <ul> <li><p>ProcessorInformation/%ProcessorTime</p> <p>LogicalDisk/Avg Disk sec/read</p> <p>LogicalDisk/Avg Disk sec/write</p> <p>Memory/Available MBytes</p> <p>SQLServerBufferManager/BufferCacheHitRatio</p> <p>SQLServerBufferManager/PageLifeExpectency</p></li> </ul> <p>Here is a great article on using perfmon, <a href="http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/" rel="nofollow">http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/</a></p> <p>The next step is optimizing query and SQL Server performance.</p> <p>Query Performance, <a href="http://technet.microsoft.com/en-us/magazine/2007.11.sqlquery.aspx" rel="nofollow">http://technet.microsoft.com/en-us/magazine/2007.11.sqlquery.aspx</a> SQL Server Performance, </p> <ul> <li><p>-Separate data and log files on different volumes (raid 10 is preferable)</p> <p>-tempdb (<a href="http://technet.microsoft.com/en-us/library/ms175527(v=SQL.105).aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/ms175527(v=SQL.105).aspx</a>)</p> <p>-configure min/max memory</p> <p>-configure lock pages in memory and instant file initialization</p> <p>-Check out this link, <a href="http://www.brentozar.com/sql/sql-server-performance-tuning/" rel="nofollow">http://www.brentozar.com/sql/sql-server-performance-tuning/</a></p></li> </ul> <p>The point is that there are so many possibilities that could be affecting your database, that it is nearly impossible to identify your problem based on the provided information. I recommend that you go through each of these items to identify why your system is not running optimally.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload