{"id":919,"date":"2012-12-29T20:56:11","date_gmt":"2012-12-29T20:56:11","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=919"},"modified":"2024-01-06T16:47:58","modified_gmt":"2024-01-06T16:47:58","slug":"july-10-2013-what-are-you-waiting-for-jason-strate","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=919","title":{"rendered":"Jul-2013 ~ What are you waiting for? ~ Jason Strate"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/06\/JasonStrate.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-77\" title=\"Jason Strate\" alt=\"\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/06\/JasonStrate.jpg\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Jason Strate<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> What are you waiting for?<br \/>\n<a title=\"Presentation Materials\" href=\"http:\/\/www.jasonstrate.com\/go\/waits2013\">Presentation Materials<\/a><\/p>\n<p><span style=\"color: #800000;\">Abstract:<\/span><\/p>\n<p>You\u2019ve spent the afternoon sweating over your T-SQL query. You\u2019ve wrung out all of the wrinkles. It\u2019s deployed, it\u2019s running\u2026 now its waiting. In SQL Server the most performant query can become a problem query if there aren\u2019t any resources in the SQL Server for it to use. In this session, we\u2019ll look at wait statistics and what they are. We\u2019ll look into how they are accumulated and how they can be monitored. By the end of the session, you\u2019ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Jason Strate is database architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His technical focuses includes administration and development of OLTP environments. Jason is a recipient of the Microsoft Most Valuable Professional (MVP) Award for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008 and 2012.<\/p>\n<p>Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings. Jason is an active blogger with a focus on SQL Server and related technologies.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Presenter: Jason Strate Topic: What are you waiting for? Presentation Materials Abstract: You\u2019ve spent the afternoon sweating over your T-SQL query. You\u2019ve wrung out all of the wrinkles. It\u2019s deployed, it\u2019s running\u2026 now its waiting. In SQL Server the most performant query can become a problem query if there aren\u2019t any resources in the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[185],"tags":[152,151,153,150],"class_list":["post-919","post","type-post","status-publish","format-standard","hentry","category-2013-events","tag-performance-tuning","tag-query-performance","tag-statistics","tag-waits"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=919"}],"version-history":[{"count":11,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/919\/revisions"}],"predecessor-version":[{"id":1133,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/919\/revisions\/1133"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}