For the past few days, I've been working on a stored procedure that was the top offender for CPU usage. I tried various index changes, played around with index hints, etc.
Read more →
This is the final blog for my PASS Summit 2011 series. Well okay, a mini-series, I guess.
On the last day of the conference, I attended Keith Elmore’ and Boris Baryshnikov’s (both from Microsoft) “Introducing the Microsoft SQL Server Code Named “Denali” Performance Dashboard Reports, Jeremiah Peschka’s (blog|twitter) “Rewrite your T-SQL for Great Good!
Read more →
Well we’re about a month past PASS Summit 2011, and yet I haven’t finished blogging my notes! Between work and home life, I haven’t been able to come up for air in a bit.
Read more →
I arrived in Seattle last Monday afternoon to attend PASS Summit 2011. I had really wanted to attend Gail Shaw’s (blog|twitter) and Grant Fritchey’s (blog|twitter) pre-conference seminar “All About Execution Plans” on Monday, but that would have meant flying out on Sunday which I couldn’t do.
Read more →
What an amazing week I had at PASS Summit 2011 in Seattle, WA! I hadn’t attended a PASS conference since September of 2005 when it was in Grapevine, Texas. It has grown so much since then.
Read more →
Today I renamed the sa account on 23 SQL Server 2005/2008 instances. I used the CMS to assist with this task. Later we realized all of the SQL Agent jobs were failing on these instances with the following error: “The job failed.
Read more →
If you use RDP to remotely connect to your servers, you've probably encountered a clipboard issue where copy/paste stops working. A quick Google search on the problem indicates you can easily fix the problem by logging out/logging back in or killing/restarting rdpclip.
Read more →
It never occurred to me that the way SSMS handles tabs could be changed, and it’s just that the default settings suck. In this blog post, Brent Ozar shows us how to fix SSMS so that the tabs are actually usable and not annoying anymore.
Read more →
Twice a year, we move our production systems to our disaster recovery site. Last Saturday night was one of those days. There are about 50 SQL Server databases to be moved to the DR site, which is done via database mirroring.
Read more →
I've been thinking about submitting my "Performance Tuning With Traces" topic for SQL Saturday #73, but I think I’m burnt out on that topic. I’ve only presented it twice (#55|#47), and I am passionate about that subject, however I need something new.
Read more →
This past Saturday, I presented "Performance Tuning with Traces" at SQL Saturday #47 in Phoenix, Arizona. You can download my slide deck and supporting files here. This is the same presentation that I did in September at SQL Saturday #55 in San Diego, however I focused less on my custom server-side trace tool and more on the steps that I take to troubleshoot a production performance problem which often includes server-side tracing.
Read more →
We’ve been having some major performance issues with one of the applications that I support. The database is on SQL Server 2005 and is about 150GB in size. We’ve identified a couple of issues already on the database side.
Read more →
Recently I opened a case with Microsoft PSS to help us through a severe performance problem on a new system. As part of that case, the PSS engineer checked our “max degree of parallelism” server-side setting.
Read more →
SQL Saturday is coming to Phoenix, Arizona on February 19th, 2011. I have submitted my session for this event. If my session gets approved, it’ll be the same presentation that I gave recently at SQL Saturday #55.
Read more →
I started my IT career as a student worker in the database team at the County of San Diego. Although I worked on many different things in that group, it launched my career as a Database Administrator.
Read more →
On Saturday (9/18), I presented "Performance Tuning with Traces" at SQL Saturday #55. There were about 65 people in attendance, and it was standing room only. As promised, you can download my presentation materials here.
Read more →
If you are interested in finding out the largest SQL projects in the world, you should check out this PowerPoint presentation. It’s from Kevin Cox of SQL CAT at Microsoft.
Read more →
SQL Saturday is coming to my hometown, San Diego, on September 18th, 2010. I have submitted my session and hope that it gets approved. Let me know if anyone is attending the event in San Diego.
Read more →
A while back I wrote a CLR object to track database growth. The CLR object queries sp_databases for each passed in server and saves the data into a table. By using this CLR object, I can track all of my systems in one location.
Read more →
Last November, I blogged about a weird bug with SQL Server 2005 on a Windows 2008 cluster. We were having issues with Database Mail and other things and learned that it was due to the server names being in lower case.
Read more →