The Multifunctioning DBA:

October, 2008


October 21, 2008  8:54 PM

Modify Perfstat Statspack Job in Oracle 920



Posted by: Colin Smith
Database, DBA, Oracle

Today I was tasked to change the statspack job to get a snapshot every 15 minutes instead of once every hour. These statspack snapshots are something that Oracle does in order for a DBA to look at historical performance data. The idea in making this change is that a lot can change in one hour so we...

October 20, 2008  11:50 PM

MS SQL Server Monitoring



Posted by: Colin Smith
Database, DBA, Microsoft Windows, Powershell, SQL Server

One of the first tasks that was assigned to me after moving to the DBA team was to find and implement a monitoring solution for MS SQL Server instances. We wanted to do this in house, if possible, in order to save money. In order to do this I decided to try and use Windows Powershell. Before I...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: