by XDK
8. May 2013 09:46
Problem
The load test rig database was configured on SQL Server 2008 express edition which can hold maximum database size of 4 gb
Workaround
Note: Always test the blog script on your test environment before executing on production environment
This problem can be overcame by removing historical results
-- Start Script
-- This script deletes all load test run older than two weeks
-- To change the timeframe, change the number of days from 14 to the desired number
USE LoadTest
DECLARE @LoadTestRunId int
DECLARE OldLoadTestsCursor CURSOR FOR
SELECT LoadTestRunId FROM LoadTestRun WHERE datediff(dd, StartTime, getdate()) > 14
OPEN OldLoadTestsCursor
FETCH NEXT FROM OldLoadTestsCursor INTO @LoadTestRunId
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC Prc_DeleteLoadTestRun @LoadTestRunId
FETCH NEXT FROM OldLoadTestsCursor INTO @LoadTestRunId
END
CLOSE OldLoadTestsCursor
DEALLOCATE OldLoadTestsCursor
-- End Script
Script Reference : http://blogs.msdn.com/b/billbar/archive/2006/02/09/528900.aspx
Solution
Configure the rig to other editions of SQL server.
Subscribe