No more excuses of missing indexes with Activity Monitor in SQL Server 2008

The new version of Activity Monitor for SQL Server 2008 Management Studio has a new look and feel from the old one in 2005. The new Activity Monitor has a Recent Expensive Queries pane that allows you to see which of your active queries based on the data in the dm_exec_requests DMV. By default the…

3

Where is that darn Activity Monitor in SQL Server 2008?

Technorati Tags: SQL Server 2008,Activity Monitor,SSMS You may have heard – we rewrote the Activity Monitor from the ground up. However, I’ve seen feedback on the Connect site and from others looking at SQL Server 2008 who claim they can’t find the Activity Monitor. Well – I guess I learned a lesson – don’t willy-nilly…

3

Installing the SQL Server 2008 R2 Management Pack for System Center Operations Manager 2007 R2

By Bill Ramos Principal Program Manager, SQL Server Manageability Abstract In this blog post, I will go over the steps to install System Center Operations Manager (SCOM) 2007 R2 and the recent release of the SQL Server 2008 R2 Management Pack (MP) on a bare bones Windows Server 2008 R2 Hyper-V virtual machine.  I’ll include…

3

Search in Object Explorer Details Window

There have been quite a few blog postings about the new Search feature in SQL Server 2008 Management Studio. Here are some examples of what you can find: MSDN – Using Object Explorer Details and SQL Server Object Search Buck Woody’s Carpe Datum – SQL Server 2008 Improvements Practical’s – Object Explorer Details Brad McGehee…

2

Enabling SQL Server Management Pack Alerts with System Center Operations Manager 2007 – Enabling the Blocking Sessions Rule

Bill Ramos, Principal Program Manager, SQL Manageability In my previous blog post Installing the SQL Server 2008 R2 Management Pack for System Center Operations Manager 2007 R2 I showed how you can install SCOM 2007 R2 on a “bare-metal” VM using  SQL Server 2008 R2 as the back end. One of the big features of…

2

SQL Server Management Studio Tips – Part 2

This is the second in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog. As I mentioned in Part 1, many of the commands are documented in the  SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts.   Blog…

2

New Activity Monitor – What you should know about the Refresh Interval

Now that you know where to find the Activity Monitor in SQL Server 2008 Management Studio, here are some things you should know about how the refresh interval works that isn’t completely documented. Unlike the previous version of the Activity Monitor (AM), the new AM starts up with a 10 second refresh interval. That doesn’t…

2

SQL Server Agent and Database Mail – Better Together

This post is how to configure SQL Agent to use Database Mail for sending an email to an operator in the event a job fails. I was hoping that there was a single MSDN topic on how to do this, but no such luck. The steps are fairly straight forward, but I managed to get…

2

Database Manager for IIS 7 RC Preview

I recently had a chance to preview the Release Candidate of Database Manager 1.0 for IIS7. If you are looking for a very lightweight tool that is easy to install for doing basic operations against SQL Server used by your IIS applications, this tool is just for you. It’s much smaller than SQL Server 2008…

2

DAT315 – Session Review for SSMS Tips & Tricks Session

One of the attendees of my TechEd session “DAT315 – Manageability Series: Uncover Hidden Secrets of T-SQL Scripts with Microsoft SQL Server Management Studio” suggested that I post the list of demos that I did for the session so that they could remember the ah-ha moments. Here we go. Object Explorer Details (OED) The property…

2