Archives: November 2009
AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011. The gist of it is that AMD may be competitive with Intel in some parts of the market (two-socket servers), which is very good news for the industry. If Intel… Read more
I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus class, held in the Josephine Computer Lab. The textbook is Beginning SQL Server 2008 for Developers by Robin Dewson. The ten week class is worth four units in the Master’s… Read more
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server.
I have added several new queries this time, and tweaked… Read more
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the Xeon 5500 series, Nehalem-EP processor). This unit has six cores, and hyper-threading for a total of 12 cores per physical processor. The L3 cache is bumped up to 12MB. This… Read more
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it can sometimes be difficult to keep track of whether you have used certain options (such as RECOMPILE). The queries below show some different things you can discover by querying sys.sql_modules… Read more
During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in the Windows Division partnered with Acer to learn what a hardware manufacturer goes through when they design and configure a laptop computer. This story went on for several minutes, and… Read more
Back before I grew up and became a DBA, I used to be a developer. This seems to be a fairly common career path for many DBAs that I have met. At any rate, I can relate to and understand developers somewhat better because I used to be one, and… Read more
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1. You can go here to request the hotfix from Microsoft. It typically takes just a few minutes for them to send you the download link and password, then you have to download and unzip with the…
We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over a year, with very good results. We were able to replace a 3rd party solution that required a lot of attention, maintenance, and extra hardware, with a very simple iFTS… Read more
Kimberly Tripp posted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS bookstore sold out of all of their copies of the book (150 in all), and many people who bought the book waited patiently in a long line to have… Read more
If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you have to do is take a full backup of the database that you want to mirror. You can either back it up locally and copy the backup file(s) over the… Read more
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800 and four Dell PowerEdge 1950 servers that were running a number of busy, large SQL Server 2008 databases. We had previously done some vertical partitioning (splitting different application functionality across… Read more
One feature of Windows 7 that you may not have heard of is Windows XP Mode on Windows Virtual PC. These allow you to use hardware assisted virtualization (if your processor supports it, and you have it enabled in your BIOS) to run guest operating systems. Windows XP Mode… Read more
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This system has a 1.6GHz Core i7 Q720, 6GB of RAM, a 7200rpm 500GB drive and an ATI HD Radeon 4830 with 1GB of video memory. The max screen resolution is… Read more
Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server 2008 version here. Most of the DMV queries require VIEW SERVER STATE permission.
-- SQL Server 2005 Diagnostic Information Queries -- Glenn Berry -- November 2009 -- http://glennberrysqlperformance.spaces.live.com/ --…
Temporary Post Used For Theme Detection (3d1489bf-65cc-47a0-b394-b28676998db9 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e29f86d1-0b33-4a68-adcd-77248245d9b5 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page that will completely document all of the wait types from the sys.dm_os_wait_stats DMV. There will be more detailed and practical information about the individual wait types compared to what… Read more
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already passed Snow Leopard and Linux in market share. Windows 7 is really a nice operating system that you quickly grow very used to in daily use. All my machines at… Read more
During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a pre-release build of SQL Server 2008 R2 Datacenter Edition on Windows Server 2008 R2.
The demo started out with 64 processor cores running at about 90%. Bob pushed a button,… Read more
Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be two new, high-end SKUs of SQL Server 2008 R2, and the prices of Standard and Enterprise Edition are going to be increased somewhat over SQL Server 2008.