Why and when denormalisation makes sense.
Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
If you want to understand how to load data into Sql Server very quickly then this is the session for you.
This session will investigate using Stream Insight, SQL Server and Analysis Services to provide an example framework to monitor cube usage as well as suggest a mechanism for highlighting areas for performance and security enhancements.
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware.
Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration. This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance.
Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be! Fast Track is a great solution with a fantastic value proposition.
In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions:
* When might I need Fast Track?
* What is Sequential I/O?
* How does Sequential I/O improve performance?
* What do I need to do to get Sequential I/O?
* How can I monitor for Sequential I/O ?
* What may I need to change in my ETL to get the benefit of sequential I/O?
Still reading? I'll save you a front row seat....
Everything you need to know to get up and running with this new technology
Increase the "out of the box" performance and throughput of SQL Server.
What HA options will help me in reality?
Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net.
You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.
This demonstration shows you how to manage database changes using source control within SQL Server Management Studio.
A challenge to traditional patterns of processing, storing and retrieving the precious data that we are responsible for
Understand the Query Optimiser from the man who knows!
Learn to tune Analysis Services 2008 query performance
See the lessons learned from stressing 128 cores
A typical day of DBA and new features of SQL Server 2008 can help - save a minute.
In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms!
Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD.
I don’t have a quad core laptop yet, so I will do the best with my dual core!
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect, resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
Learn to love SCOM!
Out of the box the SCOM Management Pack for SQL Server is not popular with DBA's. This demo based session will take you through the process of how you can extend SCOM to properly monitor and analyse SQL performance. Ultimately providing performance management scorecards and dashboards for your CIO.
With examples we will discuss tips and tricks that will be useful for Developers, DBAs and Consultants.
If you've ever needed to review large Performance Monitor (PerfMon) logs and find problems quickly - you'll know how time consuming it can be to identify problems.
Performance Analysis for Logs (PAL) is a great tool to quickly highlight performance problems - taking the leg-work out of PerfMon log analysis.
This session will reveal the basics of analyzing crash-dumps in order to troubleshoot SQL Server crashes or abnormal situations. We will also review the postmortem analysis of common (but tricky) development problems, such as connection leaks, using WinDbg and Adplus.
SQL Server 2008 provides a lot of scaleout technologies.
This session covers the new scalability features of SQL Server Reporting Services 2008 and demonstrates how to build a high performance reporting platform to deal with your enterprise reporting needs.
SQLSentry Optimizing SQL Server Performance