Could not access the load test results repository: The load test results repository is out of space. Allocate more space to the repository (if possible), or delete results of the older load test runs.

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.


 

Tags:

Web Performance & Load Tests

Comments are closed

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

About the author

My name is Xavier Dilip Kumar Jayaraj having 13+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

CategoryList