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.
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. I’m still trying to get to the root cause.
2. Four SQL 2005 installs on non standard servers in one of our environments.
– one had reporting services with it
3. Log Shipping – I sent up two environments with Log Shipping on four primary servers.
- Two had native log shipping
- Two has SQL Lite Speed Log Shipping
4. A few performance issues that I will post about later.
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
- Two SQL 2005 64 bit Log Shipping servers
- Three SQL 2005 Utility servers
- Eight SQL 2005 Express servers
- One SQL 2000 utility server
- I spent most of the week in in the “War” room with a consultant from Microsoft.
- High CPU, slower performance issue on the biggest database
- We updated statistics with full scan and things were under control.
- Here’s some information on:
- Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
- Contiunied to get the performance testing environment up to speed and level set with production – all 16 SQL servers listed above are replicated in our performance testing environment.
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 SQL version column – anyway that was a couple of hours of work to fix.
2. I had to document all the servers post installation which mainly focused on some standard settings and some user login information. I’m planning a separate post for these issues.
3. I was asked to tune a report that was using sys.dm_db_index_physical_stats on a large DB. It was taking 45 minutes to run – if it returned data or not. I plan to write a separate post on this as well.
4. I found this blog from a guy who’s got some pretty good tips.
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 of them had between 8 and 32 GB of ram, between 4 and 8 processors and one had almost 3 TB of disk space. It’s a bit of a different environment.
Here’s some good site I found on Clustering and SQL performance:
SQL-Server-Performance’s – SQL Server 2005 Clustering Best Practices
Microsoft’s – Clustered SQL Server do’s, don’ts, and basic warnings
Technet’s – Top Tips for SQL Server Clustering
And some more from Microsoft
SQL Server 2005 Failover Clustering
SQL Server 2000 Failover Clustering
Windows Server 2003 R2 Enterprise Edition–Cluster Server
Microsoft Cluster Server Administrator’s Guide
Microsoft Virtual Server 2005 R2
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 70-444 exam soon.
I am officially a Microsoft Certified Technical Specialist for SQL Server. I passed the MCTS exam, Microsoft SQL Server 2005 Implementation & Maintenance on Tuesday.
Top 10 Hidden Gems in SQL Server 2005: “Top 10 Hidden Gems in SQL Server 2005″
I don’t know if I put this out here before or not, but here’s a link to the SQL 2008 CPT site.
SQL Server 2008 CTP: “SQL Server 2008 Community Technology Preview”