This is Michael Anderson's Typepad Profile.
Join Typepad and start following Michael Anderson's activity
Join Now!
Already a member? Sign In
Michael Anderson
Lake Stevens WA
Recent Activity
Image
I am creating this post out of order (I was planning to demonstrate I/O when various queries are applied with and without indexes – but that will have to wait for a later time. I will end up using XPERF to analyze the I/O). XPERF.EXE is the holy grail of... Continue reading
Posted Jun 22, 2011 at SQL Velocity
Image
Today's post is the second in a long series. Part one covered the Microsoft Process Monitor tool. Part will cover interpreting Process Monitor results. In my lab I have a TPC-H "Like" environment (If testing is not sanctioned by the TPC committee then you are legally obliged to call it... Continue reading
Posted Jun 1, 2011 at SQL Velocity
Image
Thanks to everyone that attended the presentation. Protect Microsoft SQL Server The Microsoft SQL Server and SQL Server Customer Advisory Teams are hard at work on SQL Server codename Denali. Stay tuned to http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx and http://sqlcat.com/Default.aspx for more information. Scale Microsoft SQL Server This blog has more information about Scalable... Continue reading
Posted May 11, 2011 at SQL Velocity
Michael Anderson is now following mmcghee
Apr 26, 2011
Image
In previous posts I outlined performance counters that can be used to view windows I/O: http://sqlvelocity.typepad.com/blog/2010/08/windows-performance-counters-for-windows.html Perfmon is a great tool for analyzing how busy a given system is. Unfortunately Perfmon needs to sample data over time and by necessity performs data smoothing. If a tool only captures data every... Continue reading
Posted Apr 26, 2011 at SQL Velocity
My Friend James Roland Jones, EMC SQL Server MVP from the UK, has an excellent post that details how SQL Server loads data using the -E flag. http://consultingblogs.emc.com/jamesrowlandjones/archive/2010/04/25/focus-on-fast-track-understanding-the-e-startup-parameter.aspx He makes great use of the Internals Viewer for SQL Server: http://internalsviewer.codeplex.com/ At some point I will need to conduct a write... Continue reading
Posted Apr 1, 2011 at SQL Velocity
Image
Wednesday, April 6, 2011 at 12:00p.m. ET/ 9:00a.m. PT I am speaking with two Microsoft colleagues and the Enterprise Strategy Group at a SQL server Magazine webcast on the topic of massive Business Intelligence scale out using Microsoft SQL Server 2008 and VMAX. I get to present with Akshaya Arora... Continue reading
Posted Mar 30, 2011 at SQL Velocity
Prior to my present employment with EMC I worked for 10 years at Microsoft; the last 5 years at adCenter. The adCenter is a truly amazing team! They managed to take an advertising platform from concept to the second biggest search advertising platform in just 5 short years. The backend... Continue reading
Posted Mar 7, 2011 at SQL Velocity
Michael Anderson is now following Jimmy May @aspiringgeek
Feb 17, 2011
Image
A quasi authoritative guide to improving the performance of Microsoft SQL Server running on EMC Symmetrix arrays Overview While attending the SQL PASS Summit in Seattle this last November, http://www.sqlpass.org/summit/na2010/, I was asked an interesting question. A DBA approached me after attending a session featuring Jimmy May from the Microsoft... Continue reading
Posted Feb 11, 2011 at SQL Velocity
Image
Performance This post is an extension of the performance section of: http://www.emc.com/collateral/hardware/white-papers/h8129-performance-scaling-sql-wp.pdf. Writing a white paper requires some brevity lest it turn into unreadable minutia. Thank goodness for blogs. Scalable shared database presents a really interesting lesson in I/O performance. As performance demands increase the DB architect has numerous tools... Continue reading
Posted Feb 1, 2011 at SQL Velocity
Image
Directing Traffic Scalable shared data base enables the merging of a scale up computer science problem (the loading and reporting of data) with a scale out solution. The scale out solution is made possible because the data is synchronized across nodes as a read only copy. This same scale out... Continue reading
Posted Jan 21, 2011 at SQL Velocity
Image
Managing Data Replication The key to Scalable Shared Data Base is role separation. Reporting tasks are moved from the primary processing node to scaling reporting nodes. This is accomplished by means of data distribution. The fully processed cube is copied from the Factor to the reporting nodes. I have used... Continue reading
Posted Dec 21, 2010 at SQL Velocity
Scalable Shared Data Base Part 2: Setting up the Scalable Shared Data Base Start setting up Scalable Shared Data Base (SSDB) by answering a question; Is my database compatible with Scalable Shared Data Base? The computer science problem that a Scalable shared data base solves is to distribute data reporting... Continue reading
Posted Oct 22, 2010 at SQL Velocity
Image
Processing data is like driving a truck. Assume there are no posted speed limits, our example truck can only travel at 50 miles per hour. If a given destination is 100 miles away and the truck can only reach the maximum 50mph it is going to take two hours to... Continue reading
Posted Sep 4, 2010 at SQL Velocity
A quick note! My team here at EMC has a brand new page dedicated to Microsoft SQL Server: http://www.emc.com/campaign/global/sql-server/index.htm There is an excellent best practices guide to SQL Server running on EMC Symmetrix Storage Systems: http://www.emc.com/collateral/software/solution-overview/h2203-ms-sql-svr-symm-ldv.pdf We work extremely hard to provide guides that help you implement excellent systems. Be... Continue reading
Posted Aug 31, 2010 at SQL Velocity
Brent - Great point reference processor measurement. CPU performance is a science un to itself. Technet has some excelent articles with more information: http://technet.microsoft.com/en-us/library/cc938609.aspx
SQL Sensi - Thanks for the Heads up. I got a bit happy with the 0 key. The post is now Fixed!
Image
It was recently brought to my attention that I neglected an important piece of information in my first post (Thanks Lance!). I get a lot of questions about the appropriate Windows Performance counters to capture for SQL server analysis. This post is cheating; from now on I get to send... Continue reading
Posted Aug 12, 2010 at SQL Velocity
Michael Anderson is now following the storage anarchist
Aug 9, 2010
Image
Hello and welcome to the first installment of SQL Velocity! Over the coming weeks and months I will be documenting best practices for high performance database installations. The focus of this material will be running SQL server on EMC Symmetrix arrays. This first installment covers separating SQL Functions to optimize... Continue reading
Posted Jul 29, 2010 at SQL Velocity
Michael Anderson is now following The Typepad Team
Jul 8, 2010