The core of a relational database is normalization. The reduction of data duplication is what it is all about. Less data means less IO. SDS removes database design from the equation. This is why sparse columns and filtered indexes where implemented in SQL Server 2008. Here are a few posts on how this is handled in SDS.
The End of of JOINs?
The End of JOINs Part 2?
Yah yah, it doesn’t apply to your job, business, sector. Adam may call me out on FUD again. I hope it is true since this is hopeware so far.
However, I want to point out one company who have found a cloud non-relational database to meet their business requirements. They state their limitations and it makes sense as to why they took this route. If you are not up to speed, Simpledb is Amazon’s cloud db. Big table is Google’s cloud db. You are here because you already know about MSFT.
Glue chooses SimpleDB.
This is what we need to keep an eye on.
It has often been said that even the most write intensive OLTP databases have an average of 80% reads and 20% writes. I am thinking interactivity has increased in applications because technology has allowed it to get more write intensive but I am just guessing.
Run this on your OLTP Crown Jewels and post the results. While not very scientific, it will give us some anecdotal data. The query could also be useful when sizing new hardware.
I came up with 97/3, 74/26 and 60/40 on three high volume databases.
--This query has minimal impact. --Looks at index metadata to determine read\write ratio since the last restart of the instance.SELECT CAST(SUM(user_seeks+user_scans+user_lookups) AS decimal)/CAST(SUM(user_updates)+SUM(user_seeks+user_scans+user_lookups) AS decimal) AS ReadPercent, CAST(SUM(user_updates) AS decimal)/CAST(SUM(user_updates) + SUM(user_seeks + user_scans + user_lookups) AS decimal) AS WriteRatioFROM sys.dm_db_index_usage_statsPost your results!email it! | | | Permalink 15 CommentsSQL shorts Posted by Jason Massie on Friday, March 21, 2008 at 1:27 PM to SQL Server 2008, SQL Shorts, SQL Server 2005, Windows Server 2008, tsql, Indexes, Offtopic, Virtualization, CTP6 2409 Views | 1 Comments | We regret to inform you of a passing in the SQL community. Read more here.Rick Heiges has a post on my favorite new feature in SQL Server 2008, filtered indexes. So does Decipherinfosys along with a good description on the difference of indexes and statistics if you need some background.SQLBlogcasts has gotten an upgrade and Tony posts some great stats. Congrats!Not SQL per say but the Hyper-V release candidate has been released. Speaking of Hyper-V, Sriram posts his slide decks on virtualizing SQL. Part 1 and Part 2.This is a great starting point for SQL Server 2008 as is this. These come by way of the MSDN\Technet update blog.The SQL Server 2005 sp3 debate continues.The SQL ISV team posts a performance improving cursor rewrite sample. However, it is not ANSI compliant :) which is odd since most ISV tsql code needs to be portable.Paul Nielson will be releasing a DVD.While we are at it, check out the new SQL Server social network.alt head: Got ADD?Technorati Tags: SQL Server,SQL Server 2008,SQL Server 2005,SQL Server 2000,tsql,cursors,virtualization,filtered indexes,social networking email it! | | | Permalink 1 CommentsSQL Shorts Posted by Jason Massie on Friday, February 29, 2008 at 12:12 PM to SQL Server 2008, SQL Shorts, Windows Server 2008, Heroes Happen Here, Boohoo, Data collection 2032 Views | 0 Comments | The big news of the week was the HH{H} launch. A lot of marketing fluff. Not just from MS but from vendors trying to ride the wave. That said, I think the rest of the year is going to be really exciting technology wise.There are some good webcasts at the virtual event site through the slick but slightly buggy silver light interface. Check it out.The MS SQL site got a facelift. I suspect it will replace the original site soon. Props to ThePremiers for breaking it.Dan reports the return of the tsql debugger, object search and the new activity monitor. He demo'd these features and the other manageability features at the launch event. SQL Server 2008 is setting records. Most impressively in loading 1TB+ in 30 minutes with SSIS. Read it on the SQLPerf site here and here, the SQLCAT site, Erin's blog, and Denis's blog.Peter has the scoop about issues with SQL Server 2008 and leap year. Whoops :) Good thing they didn't launch today.Linchi comments on the intel hexacore procs that should hit Q3-4.Derek C drops knowledge on the SQL Server 2008 performance data collector.This might be HAWTALTA to some but I consistently here people complaining about the speed of SQLWB. Jeff posts links to resources.Bonnie posts the 2008 version of samples on codeplex. Direct dl here. Details here.Check out this very detailed post on SNAC for the horse's mouth.Andy has a no nonsense post on sparse columns.I should have mentioned this last week. Simon did a great job in detailing full text in SQL Server 2008 in a series of posts. Start here. Have a great weekend!email it! | | | Permalink 0 CommentsSQL Shorts Posted by Jason Massie on Tuesday, February 05, 2008 at 10:02 PM to Certifications, SQL Shorts, Windows Server 2008 1096 Views | 0 Comments | The big news of the week is Windows Server 2008 RTM'ing. Read more here.The storage engine team has begin a series on bulk insert. It is definitely recommended reading. Part 1, Part 2, Part 3.The SQL Server development customer advisory team has launched http://SQLCAT.com. They have some nice content.There is some interesting commentary on obtaining certs on SQL here.Simon S. releases a new version of the spatial viewer on codeplex. Get yer spatial on! Edit:This one just missed post but it looks cool so I will add it in,Danny has just released a new SSMS plug in that can color code your connections. That way there are no more OMG moments.email it! | | | Permalink 0 CommentsSQL Server Shorts Posted by Jason Massie on Wednesday, January 30, 2008 at 7:07 PM to SQL Server 2008, SQL Shorts 843 Views | 1 Comments | Dan Jones provides some interesting insight into the development process of SQL Server 2008.SQL Customer Advisory Team releases a partition management utility on CodePlex.The storage engine team continues the data compression series. This time they cover data compression strategies. I am really looking forward tow planing with this in the next CTP.Lastly, it is a sad week in the SQL Server world as we lost a living legend. Ken Henderson passed Sunday. Many bloggers paid homage. A few include Kalen Delaney, Bill Ramos, WelselyB, Sean McCown.email it! | | | Permalink 1 Comments
--This query has minimal impact.
--Looks at index metadata to determine read\write ratio since the last restart of the instance.SELECT CAST(SUM(user_seeks+user_scans+user_lookups) AS decimal)/CAST(SUM(user_updates)+SUM(user_seeks+user_scans+user_lookups) AS decimal) AS ReadPercent, CAST(SUM(user_updates) AS decimal)/CAST(SUM(user_updates) + SUM(user_seeks + user_scans + user_lookups) AS decimal) AS WriteRatioFROM sys.dm_db_index_usage_stats
Post your results!
We regret to inform you of a passing in the SQL community. Read more here.
Rick Heiges has a post on my favorite new feature in SQL Server 2008, filtered indexes.
So does Decipherinfosys along with a good description on the difference of indexes and statistics if you need some background.
SQLBlogcasts has gotten an upgrade and Tony posts some great stats. Congrats!
Not SQL per say but the Hyper-V release candidate has been released. Speaking of Hyper-V, Sriram posts his slide decks on virtualizing SQL. Part 1 and Part 2.
This is a great starting point for SQL Server 2008 as is this. These come by way of the MSDN\Technet update blog.
The SQL Server 2005 sp3 debate continues.
The SQL ISV team posts a performance improving cursor rewrite sample. However, it is not ANSI compliant :) which is odd since most ISV tsql code needs to be portable.
Paul Nielson will be releasing a DVD.
While we are at it, check out the new SQL Server social network.
alt head: Got ADD?
Technorati Tags: SQL Server,SQL Server 2008,SQL Server 2005,SQL Server 2000,tsql,cursors,virtualization,filtered indexes,social networking
The big news of the week was the HH{H} launch. A lot of marketing fluff. Not just from MS but from vendors trying to ride the wave. That said, I think the rest of the year is going to be really exciting technology wise.
There are some good webcasts at the virtual event site through the slick but slightly buggy silver light interface. Check it out.
The MS SQL site got a facelift. I suspect it will replace the original site soon. Props to ThePremiers for breaking it.
Dan reports the return of the tsql debugger, object search and the new activity monitor. He demo'd these features and the other manageability features at the launch event.
SQL Server 2008 is setting records. Most impressively in loading 1TB+ in 30 minutes with SSIS. Read it on the SQLPerf site here and here, the SQLCAT site, Erin's blog, and Denis's blog.
Peter has the scoop about issues with SQL Server 2008 and leap year. Whoops :) Good thing they didn't launch today.
Linchi comments on the intel hexacore procs that should hit Q3-4.
Derek C drops knowledge on the SQL Server 2008 performance data collector.
This might be HAWTALTA to some but I consistently here people complaining about the speed of SQLWB. Jeff posts links to resources.
Bonnie posts the 2008 version of samples on codeplex. Direct dl here. Details here.
Check out this very detailed post on SNAC for the horse's mouth.
Andy has a no nonsense post on sparse columns.
I should have mentioned this last week. Simon did a great job in detailing full text in SQL Server 2008 in a series of posts. Start here.
Have a great weekend!
The big news of the week is Windows Server 2008 RTM'ing. Read more here.
The storage engine team has begin a series on bulk insert. It is definitely recommended reading. Part 1, Part 2, Part 3.
The SQL Server development customer advisory team has launched http://SQLCAT.com. They have some nice content.
There is some interesting commentary on obtaining certs on SQL here.
Simon S. releases a new version of the spatial viewer on codeplex. Get yer spatial on!
Edit:
This one just missed post but it looks cool so I will add it in,
Danny has just released a new SSMS plug in that can color code your connections. That way there are no more OMG moments.
Dan Jones provides some interesting insight into the development process of SQL Server 2008.
SQL Customer Advisory Team releases a partition management utility on CodePlex.
The storage engine team continues the data compression series. This time they cover data compression strategies. I am really looking forward tow planing with this in the next CTP.
Lastly, it is a sad week in the SQL Server world as we lost a living legend. Ken Henderson passed Sunday. Many bloggers paid homage. A few include Kalen Delaney, Bill Ramos, WelselyB, Sean McCown.