Browse by Tags
» internals (RSS)
Showing page 2 of 3 (24 total posts)
We've got two sessions that you need to sign up
for right away. The upcoming webcast for Oracle-oriented folks has huge
registration numbers. So get in while you still can before we hit the
limit of what LiveMeeting can handle.
of the Week: SQL Server for the Oracle DBA
Webcast: SQL Server for the Oracle DBADate:
Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...
For want of a nail the shoe was lost.
For want of a shoe the horse was lost.
For want of a horse the rider was lost.
For want of a rider the battle was lost.
For want of a battle the kingdom was lost.
And all for the want of a horseshoe nail.
I'm now in the middle of severity A case that is best depicted by this ...
It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own. In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how many times you shoot them, they just keep coming back.
Here’s a good case in point, ...
It seems like questions always come up about how to monitor memory. But each time the question comes up, it’s slightly different.
Here’s a sort of FAQ for memory questions:
1. How can I figure out memory and CPU consumption by database?
a. In SQL Server 2005, DMVs are of course the way to go. Pre-SQL ...
Everytime a good product comes out, people seem to contrive bad ideas for what can be replaced, usually brains, or people with brains, or that people lacking brains can accomplish something on their own.
Let me put it simply. Suppose one had a query that uses a nonclustered index, and required a key lookup, and the key lookup required a disk ...
An observant person has probably noticed that SQL queries requiring disk reads not only have longer duration but also higher CPU times. It is not hard then to deduce that disk access (for both HDD and SSD), which involves the OS performing an IO call, the SQL Server process finding a place in the buffer cache for the data pages, and possibly ...
You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient.
A good place to start troubleshooting is, of course, PerfMon. But PerfMon can fail to reveal the culprit, since the CPU can remain stable and moderate ...
If you’ve ever taken the time to read http://www.tpc.org/results/FDR/TPCC/hp_orca1tb_win64_fdr.pdf, you might find a bit in there that’s confusing.
''Microsoft SQL Server 2005 Enterprise Edition 64-bit Service Pack 1 was configured to utilize ''soft NUMA'', a feature that allows network connections to be affined to specific groups of CPUs ...
If you're well-versed in using PerfMon, I'd like to hear about the counters that you use regularly and what constitutes a good or bad value.
However, it's a rare individual who knows their way around PerfMon and its multitude of performance objects and counters. Which ones should you track? And even if you know the ...