The Multifunctioning DBA:

October, 2008


October 21, 2008  8:54 PM

Modify Perfstat Statspack Job in Oracle 920

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith
Exchange Server ActiveSync

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: