David Orlo .com | Tag Archives: Logs

Disk Optimization for SQL Servers & Databases

Posted on May 19, 2014 by David Orlo

One of the easiest ways to improve the lifetime performance of a SQL Server database is proper setup of the physical and logical drives. While it’s an easy technique, proper disk subsystem configuration is often overlooked or handled by a member of the IT staff other than a SQL Server DBA. Table of Contents: Storages specific terms Best RAID level for your system? Best practices for drive and physical file layout configuration Drive layout examples for SQL Server systems All too often the disk subsystem, including the disk array, is configured based only on storage capacity, with no question of

LogFlush Tool Source Code

Posted on May 2, 2012 by David Orlo

I have completed the LogFlush tool less a few extra features which I plan to add later. In the meantime here is the source code for the project. The tools is divided into 2 executables, 1 for the configuration and another which is the main task. The configuration data is stored in the registry and the task executable can be called at any time from a scheduler and it will call the last saved settings from the registry. Completed project is located at the link below with a self extracting installer http://ittechtools.net/windows/admin/logflush-intelligent-log-maintenance-application-with-recursive-folder-scanning The closest Syntax I could find is VB so some of