Some of you may have noticed a few SQL errors in the past few days. The Asylum db was getting quite large thanks to a few overzealous logfiles. I have since performed some quick maintenance of the db and freed up about a third of the entire db size. I will be doing more maintenance as part of the upgrade/changeover to AutomaticRespawn.com (which will happen in the next couple months, now that my studies are over TOMORROW).

[UPDATE] Site performance cannot wait for any stupid test. I continued my clean-up process and managed to free up even more space. See for yourself with the before and after results:

before:
database_size: 297.00 MB
unallocated space: 0.03 MB
data: 185032 KB
index_size: 14048 KB


after:
database_size: 297.00 MB
unallocated space: 150.70 MB
data: 39696 KB
index_size: 6896 KB

As usual with any website change, let me know if something is not working fine. In case the site is down, you can reach on on Twitter, Facebook, Xbox Live or Google+ with my username (Thryon).

Received a SQL error today upon signing into the website. Sign in still worked.
Details below:

SQL Exception
Error Details
File
Error Index #: 0
Source: .Net SqlClient Data Provider
Class: 17
Number: 1105
Procedure: AddEventLog
Message: System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.EventLog' in database 'xbo0802509221478' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)



Unauthorized Access Error
Error Details
File D:\Hosting\2842173\html\home\Portals\_default\\Logs\LogFailures.xml.resources
Error Access to the path 'D:\Hosting\2842173\html\home\Portals\_default\Logs\LogFailures.xml.resources' is denied. The Windows User Account listed below must have Read/Write Privileges to this path.