November 3, 2008 11:00 AM
Posted by: Denny Cherry
END CONVERSATION,
RECEIVE,
Remus Rusanu,
SEND,
Service Broker,
SQL Server 2005,
SQL Server 2008,
T/SQLA while back I was talking to a Microsoft Support Engineer and he had mentioned that in a high load Service Broker environment such as ours there can be some impressive performance improvement can be achieved by reusing the service broker sessions.
The cost of creating and closing a new...
October 16, 2008 11:00 AM
Posted by: Denny Cherry
Cache,
SQL Server 2005,
SQL Server 2008,
sys.allocation_units,
sys.dm_os_buffer_descriptors,
sys.partitions,
sys.tablesHere's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache. It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk.
SELECT...
September 1, 2008 11:00 AM
Posted by: Denny Cherry
distrib.exe,
logread.exe,
OutputVerboseLevel,
Replication,
replmerg.exe,
snapshot.exe,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008The error reporting in SQL Server Replication isn't all that great. This is a well known issue that pretty much everyone knows about. Something that I don't know if a whole lot of people know about, is that there is a way to get a lot more information from replication about what's going on, and...
August 26, 2008 7:55 PM
Posted by: Denny Cherry
Capacity Manager,
Consolidation,
David Swanson,
Performance Problems,
Quest Software,
SoSSE,
SQL Server 2005,
SQL Server 2008The webcast which I did for Quest Software called Don’t Consolidate Yourself Into Performance Problems is now available for viewing after the fact.
This is the webcast which I did
August 21, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Code Camp,
In Person Events,
Service Broker,
SoCal Code Camp,
SQL Server 2005,
SQL Server 2008,
StorageI and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th...
August 14, 2008 11:00 AM
Posted by: Denny Cherry
In Person Events,
New Jersey SSUG,
Service Broker,
SQL Server 2005,
SQL Server 2008After months of waiting the time is finely here. I'll be speaking at the
August 13, 2008 1:05 AM
Posted by: Denny Cherry
Capacity Manager,
Consolidation,
David Swanson,
Performance Problems,
Quest Software,
SoSSE,
SQL Server 2005,
SQL Server 2008Consolidated too many databases or too many instances onto a single server? Got users screaming for their own servers back?
Join myself and David Swanson from Quest Software (and frequent poster on
