Today I became ….. certified database administrator – I passed the final exam 70-444. After more than 10 years of administering databases – I finally officially did it.
|
||||||
|
Check Activity Monitor Anything running? SQL Error Log Any errors? If so investigate Resource utilizations DMVs sys.dm_exec_query_stats Look at: Total physical reads, logical reads, number to executions, total time, (divide those two to get average) Performance Monitors Processor Time Batch requests/sec SQL Wait stats Here’s this week’s challenges…. 1. Ran SQLIOStress test on all servers in one environment – here’s an overview of what it does – I did graph the results and found that although the configurations where nearly the same on two of our top end servers – the speed was slightly better on one. [...] Here’s this week’s weekly challenges…. New release went out last Friday, 4/18/08 – lots and lots of SQL servers Two SQL 2005 Clustered 64 bit I spent most of the week in in the “War” room with a consultant [...] This was another fun filled week with new SQL issues I hadn’t experienced in smaller environments. 1. I installed the wrong version of SQL on a server. It was a miscommunication between the network guy and myself as I read the OS column which was supposed to be Enterprise – I assumed it was [...] It’s been a heckuva week…At my previous job, I went from working with one big beefy 64 bit, dual processor, with 4 GB of RAM and about 200 GB of total space. This week, I installed and configured SQL 2005 64 bit edition on two two-node clusters and three single node clusters. All [...] I’ve been working on some disaster recovery plans and here’s what I’ve come up with for my server recovery plan. DOCPDF Today I took the Microsoft Exam 70-443: “PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005″ and I passed. That’s one step closer to certification for SQL 2005. I over studied and I’ve got all the correct Microsoft answers in my head, so I’m going to try to schedule the [...] I am officially a Microsoft Certified Technical Specialist for SQL Server. I passed the MCTS exam, Microsoft SQL Server 2005 Implementation & Maintenance on Tuesday. While researching an issue we were having, I really started studying the COGIPF_RUNREPORT table and found the COGIPF_LOCALTIMESTAMP column has the start time of the report while the report is running and the end time once the report completes. Note the COGIPF_RUNTIME will be 0 while the report is running. Thus I’ve [...] |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||