|
|
|
|
Checking out SQL Server via empirical data points
Browse by Tags
All Tags » Architecture (RSS)
-
Okay, it’s a bit of a hyperbole. But let me elaborate. I regularly bump into SQL Server discussions, online or elsewhere, in which I hear people speaking with confidence that an operation is so and so because it is doing sequential disk I/Os or because Read More...
|
-
Is it better to move data to procedures or move procedures to data? The answer is, of course, “it depends.” Let’s consider a scenario where you have two SQL Server instances: ServerA and ServerB, and you have a procedure on ServerB (call it procB), but Read More...
|
-
I always like simple frameworks that help put some order into chaos. Last month while in Seattle, I ran into something that for whatever reason had managed to escape my radar screen. If there was a single thing that made the trip to Seattle worthwhile, Read More...
|
-
In one of their year 2000 papers— Rules of Thumb in Data Engineering , Jim Gray and Prashant Shenoy stated that, “Over the last decade, disk pages have grown from 2KB to 8KB and poised to grow again. In ten years, the typical small transfer unit will Read More...
|
-
Alan Cranfield on the SSWUG list alerted me to a paper by Mike Stonebraker and folks, proclaiming the end of the current relational database architecture that is generally embraced by all the major commercial relational DBMS and annoucing that a far better 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...
|
-
There seems to be a consensus that we are at an important inflection point in computing because of the emerging trend towards multicores on a chip near term and manycores on a chip in a not so distant future. If you are writing software, you need to have Read More...
|
-
Right now, flash memory-based solid state drives are still more expensive than traditional disk drives in terms of the cost per gigabyte. But flash-based drives or some type of hybrid that combines both flash and traditional disk drives seem to be coming. 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...
|
-
The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully: SQL Server uses the following steps to set up another page for flushing and Read More...
|
-
SQL Server 2005 does not support hash partition as a product feature. But that doesn't mean you can't apply the concept of hash partition in your application or database design. Recently, I worked on an application that used SQL Server to persist the Read More...
|
-
Haven't we heard enough about AWE and 3GB? Yes, I bet you have, and I won't bore you with regurgitating any second-hand information or rehashing any Microsoft documentation or whitepapers. Instead, I'll give you my test results to highlight how much buffer Read More...
|
-
When it comes to the issue of 32-bit vs. x64, you can easily walk away from a presentation with an impression that going to x64 will most likely give your SQL Server application a performance boost. I'd like to show you--with some test data--that you Read More...
|
|
|
|
|
|