Anyone have a good method to determine the best fill factor and pad for an index? What is the indicator for higher or lower? Looking today at 9...
Well I know from viewing the server that the cpu usage drops from 30%-40% when running properly to 0%-1% when slow.<br /><br />Here is a graph of...
The Table has a clustered index on an identity column and a non-clustered index on a foreign key. Restarting this week no longer fixed the problem....
Pretty straight forward, it's a stored procedure with an insert statement. Procedure [dbo].[spInsFloatDataXMArchive0107] @fkpoint int, @value...
Files sizes are not increasing, the db is reusing space from previous purges.<br /><br />Here is a graph of the performance...<br /><img...
File sizes are not increasing. I made a graph and the slope was fairly steep but still took a couple hours to level off at 15 minutes.
An application that is 99% inserts runs for between 6 and 12 hours then performance suffers dramatically. Say every 2 minutes the application...
Separate names with a comma.
