troubleshooting

TSQL – Get All Queries Currently Running

August 4, 2016 | 0 Comments

This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in action ebook. The output shows the spid (process identifier), the ecid (this [...]

Autogrowth On But Database Not Growing

March 19, 2016 | 0 Comments

An issue arose where a database was giving the error: Could not allocate space for object ‘object-name’ in database ‘dbname’ because the [...]