Search results matching tags 'Links' and 'Conferences'

Presentation Links: SQL Server Performance Tuning (Quest)

BuckWoody — Wed, 21 Jul 2010 09:54:15 GMT

I worked with a team of folks brought together by Quest software, and we presented multiple sessions on SQL Server Performance Tuning. Here are the links I mentioned during those presentations:

Blitz! SQL Server Takeovers (Brent)

You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?" Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.

· SQL Server Best Practices Article: http://technet.microsoft.com/en-us/library/cc966412.aspx

· How to determine proper SQL Server configuration settings: http://support.microsoft.com/kb/319942

· Setting Server Configuration Options (SQL Server 2008 R2, other versions available) : http://technet.microsoft.com/en-us/library/ms189631.aspx

· Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations: http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx

· Checklist: SQL Server Performance: http://msdn.microsoft.com/en-us/library/ms979169.aspx

· Script Repository for SQL Server Information: http://gallery.technet.microsoft.com/ScriptCenter/en-us/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=databases&f%5B0%5D.Text=Databases&f%5B1%5D.Type=SubCategory&f%5B1%5D.Value=sqlserver&f%5B1%5D.Text=SQL%20Server

“Turn your head and cough” – Quick Health Check Using Wait Stats for the SQL Server Takeover (Kevin)

So you’ve survived the SQL Server Blitz and have made sure that your server is properly setup, configured, and under proper preventative maintenance. Now it’s time to play doctor and determining the health of your SQL Server. Kevin will slip on the latex gloves and show you how to determine the health of an unknown server and the applications running on that SQL Server with a quick physical.

· SQL Server Best Practices Analyzer (SQL Server 2008 R2, other versions available) : http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

· Microsoft Assessment and Planning (MAP) Toolkit for SQL Server 2008 (will detect all the way down to SQL Server 2000): http://technet.microsoft.com/en-us/solutionaccelerators/dd537572.aspx

· DMV Stats: http://www.codeplex.com/sqldmvstats

· SQL Server 2005 Performance Dashboard Reports: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Lose Wait Fast with Wait Stats (Brent)

It's time for you to get serious about wait loss - no, not weight loss, but wait loss. SQL Server wait stats will tell you what your queries and your server have been waiting on, and you don't even have to use Profiler or tracing! Brent will show you how to troubleshoot issues in real time and check historical data. He'll also show tools to make this process easier.

· Troubleshooting Performance Problems in SQL Server 2008 Whitepaper (2005 version also available) : http://msdn.microsoft.com/en-us/library/dd672789.aspx

· SQL Server 2005 Performance Tuning using Waits and Queues: http://technet.microsoft.com/library/cc966413.aspx

· SQL Server 2005 Waits and Queues: http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx

· OLTP Top 6 Performance Issues for OLTP Applications: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/oltp-performance-issues.mspx

· Top SQL Server 2005 Performance Issues for OLTP Applications: http://sqlcat.com/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx

PerfMon is “Irie Mon” (Kevin)

They say “irie mon” in Jamaica when everything is going well. Performance Monitor is irie! It’s an extremely important tool in the pocket of any IT professional because it’s available on every version of Windows and provides valuable performance information across all of the components of SQL Server, from the relational and storage engine to SSIS, SSAS, and SSRS. Kevin will show you how to make sense of PerfMon’s multitude of counters, how to store PerfMon data for long-term analysis, and how to correlate PerfMon

· Windows Reliability and Performance Monitor : http://technet.microsoft.com/en-us/library/cc755081(WS.10).aspx

· Overview of Windows Performance Monitor: http://technet.microsoft.com/en-us/library/cc749154.aspx

· Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005: http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx

· Troubleshooting Performance Problems in SQL Server 2008: http://sqlcat.com/whitepapers/archive/2009/04/14/troubleshooting-performance-problems-in-sql-server-2008.aspx

Data-tier Applications in SQL Server 2008 R2

BuckWoody — Tue, 25 May 2010 10:47:45 GMT

I had the privilege of presenting to the Adelaide SQL Server User Group in Australia last evening, and I covered the Data Access Component (DAC) and the Utility Control Point (UCP) from SQL Server 2008 R2. Here are some links from that presentation:

Whitepaper: http://msdn.microsoft.com/en-us/library/ff381683.aspx

Tutorials: http://msdn.microsoft.com/en-us/library/ee210554(SQL.105).aspx

From Visual Studio: http://msdn.microsoft.com/en-us/library/dd193245(VS.100).aspx

Restrictions and capabilities by Edition: http://msdn.microsoft.com/en-us/library/cc645993(SQL.105).aspx

Glen Berry's Blog entry on scripts for UCP/DAC: http://www.sqlservercentral.com/blogs/glennberry/archive/2010/05/19/sql-server-utility-script-from-24-hours-of-pass.aspx

Objects supported by a DAC: http://msdn.microsoft.com/en-us/library/ee210549(SQL.105).aspx

SQL Server for the Oracle DBA Links

BuckWoody — Wed, 28 Apr 2010 14:29:00 GMT

I do a presentation (and a class) called "SQL Server for the Oracle DBA". It's a non-marketing overview that gives you the basics of working with SQL Server if you're already familiar wtih how Oracle works. This class and these links DO NOT help you with "Why should I use Oracle/SQL Server instead of Oracle/SQL Server" - I'll assume you're already there, and if not, there are LOTS of sites to help you make that decision.

Although these links might contain slight marketing slants (I don't control them) I've tried to get the best links I can. Feel free to comment here to add more/better links.

As such, these aren't links that help you work with Oracle - they are links to help you work with SQL Server. Some of them contain more information than you actually need, others don't have near enough. Taken together (and with the class) you're able to get done what you need to do.

"Practical SQL Server for Oracle Professionals" - A Microsoft Whitepaper, probably the best place to get started: http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQLServer2008forOracle.docx

Free Training: http://technet.microsoft.com/en-us/sqlserver/dd548020.aspx

Classroom training (will cost you): http://www.microsoft.com/learning/en/us/course.aspx?ID=50068A&locale=en-us

Terminology Differences: http://www.associatedcontent.com/article/2383466/oracle_and_sql_server_basic_terminology.html

Datatype mapping between Oracle and SQL Server: http://msdn.microsoft.com/en-us/library/ms151817.aspx

The "other" direction - can still be useful for the Oracle professional to see the other side: http://blog.benday.com/archive/2008/10/23/23195.aspx

Consolidation Strategy References

BuckWoody — Tue, 09 Mar 2010 13:11:19 GMT

I have a presentation that I give on SQL Server Consolidation Strategies, and in that presentation I talk about a few links that are useful. Here are some that I’ve found – feel free to comment on more, or if these links go stale:

Consolidation using SQL Server: http://msdn.microsoft.com/en-us/library/ee692366.aspx

SQL Server Consolidation Guidance: http://msdn.microsoft.com/en-us/library/ee819082.aspx

More references for SQL Server and Hyper-V: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Virtualization-with-SQL-Server.aspx

Quick overview of Virtual Server licensing implications: http://www.microsoft.com/uk/licensing/morethan250/learn/virtualisation.mspx

SQL Server and Hyper-V best practices: http://sqlcat.com/whitepapers/archive/2008/10/03/running-sql-server-2008-in-a-hyper-v-environment-best-practices-and-performance-recommendations.aspx

High-Availability and Hyper-V: http://technet.microsoft.com/en-us/magazine/2008.10.higha.aspx

Virtualization Calculator: http://www.microsoft.com/Windowsserver2008/en/us/hyperv-calculators.aspx

May not be current, but here’s a whitepaper from VMWare for SQL Server: http://www.vmware.com/files/pdf/SQLServerWorkloads.pdf

More information on SQL Server and VMWare: http://blogs.msdn.com/cindygross/archive/2009/10/23/considerations-for-installing-sql-server-on-vmware.aspx

Server Virtualization Validation Program: http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvp.htm