Database – Buffer Pool – Clearing

Background During Database performance stressing, data is ingested into memory and written to disk. As one tries out different database table structures and Data Manipulation Languages ( DML ) queries, one often finds it useful to clean the slate in between.   Granularity Like any other operation one can target processing against the server, database, … Continue reading Database – Buffer Pool – Clearing

SQL Server :- DBCC Buffer

Background Wanted to cover a DBCC Command that is not well documented. It is "DBCC Buffer". I am not covering it cause it stands out so much, but to show a couple of troubleshooting tips that I was not previously aware of till someone else covered it. DBCC DBCC means Database Consistency Checker and it … Continue reading SQL Server :- DBCC Buffer

SQL Server – Database Files – Minimum File Size

Background There is a setting that is unfortunately difficult to determine within Transact SQL. That setting is the smallest size a data or log file can be shrunk down to. GUI SQL Server Management Studio ( SSMS ) Database Property Image Code Syntax Explanation DBCC PAGE Database FileID Pagenum 0 printopt 3 – page header … Continue reading SQL Server – Database Files – Minimum File Size

SQL Server – Unable to shrink Transaction Log file

Background Received an alert stating that we have gotten below our threshold of 10% on one of DB Servers. Thanks goodness no late night phone calls. Only saw it coming to work this morning. The good and bad about smartphone. TroubleShooting Windows Desktop Folder Image Explanation ppsivr_8.ldf is 28 GB SQL Metadata Outline Here are … Continue reading SQL Server – Unable to shrink Transaction Log file

SQL Server – Determining Size of Your Procedure Cache

Background For some work I am doing in terms of TempDB growing size, I wanted to see what role the Procedure Cache plays. We will look at the Procedure Cache in terms of number of entries and actual size. But, we will not divvy things up in terms of type nor characteristics of the contents. … Continue reading SQL Server – Determining Size of Your Procedure Cache

Microsoft – SQL Server – Database Repair

Microsoft - SQL Server - Database Repair Many years ago, when your hard-drive crashes you want to look for \ to "Norton Disk Doctor". Another excellent tool is Gibson's SpinRite. These days, if you are running Microsoft SQL Server you want do the following: Take regular full and incremental backups Set your database mode to … Continue reading Microsoft – SQL Server – Database Repair

Microsoft – SQLServer – Database \ Datafile Management – Data\Log File Shrinking

Microsoft - SQLServer - Database \ Datafile Management - Data\Log File Shrinking Sometimes one ends with MS SQL Server Log \ Data files growing quite a bit. This is especially true with log files. The reasons for big log files are a bit plentiful: Un-committed Transactions Database Mirroring partner in-admissibility Well, once the original reason … Continue reading Microsoft – SQLServer – Database \ Datafile Management – Data\Log File Shrinking