|
|
|
|
Browse by Tags
All Tags » Performance (RSS)
-
My previous post shows that data compression may not come for free, although hopefully by the RTM time the adverse performance impact on inserts will have been reduced significantly. In this post, I want to show you that data compression can enhance read Read More...
|
-
Before I begin, let me be very clear that the results I report in this post were obtained with SQL Server 2008 CTP6. Microsoft is still working on improving the performance of data compression. And in particular, the performance of inserting into a compressed Read More...
|
-
SQL Server 2008 has introduced a long sought after feature -- Data Compression. This is a great feature, and I have no doubt it'll be widely used. The key compression method is called page compression, which uses the following three techniques to reduce Read More...
|
-
In my previous post , I looked at how a typical OLTP workload may be affected by various controller cache configurations. And the conclusion was that giving too much cache (say all 512MB) to reads hurt the OLTP performance. The primary reason was that Read More...
|
-
In my previous post on the performance impact of controller cache configurations , I presented some empirical results showing the performance impact of configuring the controller cache to various read/write settings on large sequential I/Os. Why did I Read More...
|
-
In the next several blog posts, I’ll share with you some empirical results concerning the performance impact of configuring the read/write cache of a disk controller. In the comments on Joe Chang’s blog at this site on Storage Performance for SQL Server Read More...
|
-
For the past few weeks, I’ve been working on a diverse array of issues ranging from studying SQL Server performance on various multi-core processors, pondering the implications of many-core processors, troubleshooting SQL Server performance problems, Read More...
|
-
What does it mean if you see a high percentage of signal waits? Thanks to Microsoft whitepapers, presentations, and blogs, everybody would say it implies CPU pressure. Well, almost everyone except Mario Broodbakker, whose excellent blog “ Taking the guesswork Read More...
|
-
A frequently asked question is what counters should be included in a SQL Server baseline. The discussion then quickly proceeds to define a set of perfmon counters to be logged as the performance baseline. And often, people seem to have an urge to try Read More...
|
-
Andrew Kelly in a recent post here advised visiting/revisiting the SQL Server I/O basics, and I completely agree. A firm grasp of the basics can make it easy to understand some system behaviors that otherwise may be puzzling at times. A question that Read More...
|
-
To many, this is an old and tired topic, and any more mention of ad hoc queries versus parameterized queries may just send someone off the deep end. But recently I was doing some Oracle benchmarks, and the benchmark tool reported ~1,200 transactions per Read More...
|
-
In my previous post on this subject , I mentioned that I'd very much like to see the authors repeat the performance analysis of database servers on a more current processor. Well, they did. A group of researchers from Carnegie Mellon University, including Read More...
|
-
I was reading this excellent post on " Diagnosing Plan Cache Related Performance Problems and Suggested Solutions ” by the Microsoft SQL programmability & API development team, and was struck by the following statements: “ If the numbers of collisions Read More...
|
-
A significant part of my job is to evaluate how SQL Server (and sometimes other DBMSs) performs on various hardware platforms, in particular on the processors and its related chipsets as they are being released. So naturally, I’ve been paying attention Read More...
|
-
Regardless of the DBMS make or model, the transaction throughput curve of a database system is often shaped like a trapezoid. As the load level goes up initially, so does the transaction throughput. As the load level continues to go up, the transaction Read More...
|
|
|
|
|
|