Monthly Archives: January 2007

Windows Vista Editions Compared

Since I was wondering about the differences between the major Vista versions, this link shows the major differences between Vista Home Basic, Vista Home Premium, Vista Business and Vista Ultimate. Vista Enterprise is also an option. Now I just have … Continue reading

Posted in Windows Vista | 1 Comment

Another DMV a Day

High signal waits (above 20%) are another indication of CPU pressure. The results from this query are cumulative since your SQL Server has been running. – Total waits are wait_time_ms (high signal waits indicates CPU pressure)SELECT signal_wait_time_ms=SUM(signal_wait_time_ms),’%signal (cpu) waits’ = … Continue reading

Posted in SQL Server 2005 | Leave a comment

Old Movie Weekend

Since we had another weekend of mostly bad weather in Denver, I spent some time watching a couple of classic World War Two movies on DVD. The first was The Enemy Below from 1957, starring Robert Mitcheum and Curt Jurgens … Continue reading

Posted in Entertainment | Leave a comment

Grandma’s Boy

I’m watching Grandma’s Boy on Cinemax right now, and it is hilarious! It’s about a 35 year-old video game tester (Allen Covert), who gets evicted and is forced to live with his grandma just as crunch-time for a new video … Continue reading

Posted in Entertainment | 1 Comment

A DMV a Day

– Top 10 consumers of memory from Buffer Pool SELECT TOP (10) type, sum(single_pages_kb) AS [SPA Mem, Kb] FROM sys.dm_os_memory_clerks GROUP BY type ORDER BY SUM(single_pages_kb) DESC   Here are some of the common types you will see: CACHESTORE_SQLCP is … Continue reading

Posted in SQL Server 2005 | Leave a comment

Windows Vista Advice

Mary Jo Foley (formerly of Microsoft Watch and now at "All About Microsoft") has a good post were she solicits one piece of Vista advice from a group of well known Windows/Vista experts. My own thoughts are that you should … Continue reading

Posted in Windows Vista | Leave a comment

A DMV a day keeps the Doctor away

I thought I would start a short series where I put out a Dynamic Management View (DMV) query every day, for 30 days (or until I get tired of it). So here is query #1: – How much Physical RAM … Continue reading

Posted in SQL Server 2005 | 24 Comments