Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Windows 2008
Wednesday, November 18, 2009 8:34 AM

Using Perfmon with SQL Server – Part One

I held a workshop on performance tuning in Portland, Oregon yesterday, and as part of that I mentioned a process I follow for automatically collecting Performance Monitor Counters for a system. I use this data to store a baseline and then subsequently
Posted by Buck Woody | 0 Comments
Wednesday, October 07, 2009 6:50 AM

Free Hyper-V Book

I work with a gentleman here in the Pacific Northwest who joined the Microsoft Server team from VMWare, and he in turn has a good friend (John Kelbley) who wrote a book on Hyper-V that you can get for free –  you can get it here: http://www.netapp.com/hyper
Posted by Buck Woody | 0 Comments
Thursday, September 24, 2009 6:47 AM

SQL Server Best Practices: Set a Fixed Memory Size

SQL Server allows you to set a “bottom” and “top” range for memory that the Instance will use. The memory will dynamically expand and contract based on Instance need and system pressure. But this flexibility and ease of configuration can (not always,
Posted by Buck Woody | 0 Comments
Wednesday, September 23, 2009 6:11 AM

Remember to include the Standard Deviation

I do a lot of performance analysis on SQL Server Instances, and I normally start with a series of Performance Counters from both Windows and SQL Server. This gives me the ability to limit what I need to look at by seeing which Hardware and Windows components
Posted by Buck Woody | 0 Comments
Monday, September 21, 2009 7:27 AM

Book Review – Windows Server 2008 How To

In the past couple of weeks I’ve posted some articles on how to tune a Windows system for SQL Server. Microsoft SQL Server DBA’s are a bit different than a DBA on, say, a mainframe, because we also have to know the operating system we run on pretty well.
Posted by Buck Woody | 0 Comments
Thursday, September 17, 2009 8:26 AM

How Microsoft Does IT

One of my favorite ways to learn is through examples. If you’ll explain what something does and a little of how it works,and then give me an example to decompose, I usually come up to speed pretty quickly. I’ve been carrying a DVD (and CD’s before that)
Posted by Buck Woody | 0 Comments
Wednesday, September 16, 2009 6:24 AM

Opening a Windows Perfmon File in Profiler – Part Two

In a previous blog entry , I mentioned you could import a Windows Perfmon log into SQL Server Profiler. I received a note that someone was having a problem doing this, and when we looked over his situation, it turned out that he was using a Windows Perfmon
Posted by Buck Woody | 0 Comments
Monday, September 14, 2009 7:14 AM

Using Perfmon Data in Profiler

In SQL Server 2005 a great new feature was introduced into SQL Server Profiler – the ability to import Perfmon data. If you’re not familiar with one or both of those tools, SQL Server Profiler is a package included with SQL Server that can “watch” your
Posted by Buck Woody | 0 Comments
Wednesday, August 26, 2009 8:25 AM

SQL Server Best Practices: Disk Partition Alignment

OK - this one is a little more involved than the other best practices I've posted here. In fact, I'm going to have to send you off to another document at the end of this post to explain the technical background and the exact steps you need to perform,
Posted by Buck Woody | 0 Comments
Tuesday, July 28, 2009 9:11 AM

Should I stay or Should I Go?

I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and
Posted by Buck Woody | 0 Comments
Monday, May 05, 2008 6:52 AM

Windows 2008 and Replication

I mentioned in a previous post that I would point out where SQL Server 2008 takes advantage of improvments in Windows 2008 (Check out the "Windows 2008" tag below for that). I just had to share something I got today from the replication team in an e-mail:
Posted by Buck Woody | 2 Comments
Sunday, April 06, 2008 11:39 AM

Windows 2008 Terminal services and SQL SSMS

One of our Principal Architects, Eddy Bell, shared a great writeup with me that I think is a great way to leverage Windows 2008 and SQL Server 2008. It answers a need that I've seen over and over again - the ability to connect to SQL Server Management
Posted by Buck Woody | 3 Comments
 
Page view tracker