ºÝºÝߣshows by User: SQLRich / http://www.slideshare.net/images/logo.gif ºÝºÝߣshows by User: SQLRich / Fri, 22 May 2020 12:53:54 GMT ºÝºÝߣShare feed for ºÝºÝߣshows by User: SQLRich Investigate SQL Server Memory Like Sherlock Holmes /slideshow/investigate-sql-server-memory-like-sherlock-holmes/234468327 sqlkonferez2020-sentryone-memory-200522125354
Memory is one part of the holy trinity of resources consumed by SQL Server, the others being CPU and disk. Most people know how to look at disk latency and throughput and then take remedial measures to fix those issues. But what about memory issues? In this session, you will learn how SQL Server uses memory and various caches, how to gauge memory pressure, and how to address the significant problems it can cause. You will leave with a much clearer understanding of how to monitor and manage memory consumption within SQL Server using native Dynamic Management Objects.]]>
Memory is one part of the holy trinity of resources consumed by SQL Server, the others being CPU and disk. Most people know how to look at disk latency and throughput and then take remedial measures to fix those issues. But what about memory issues? In this session, you will learn how SQL Server uses memory and various caches, how to gauge memory pressure, and how to address the significant problems it can cause. You will leave with a much clearer understanding of how to monitor and manage memory consumption within SQL Server using native Dynamic Management Objects.]]> Fri, 22 May 2020 12:53:54 GMT /slideshow/investigate-sql-server-memory-like-sherlock-holmes/234468327 SQLRich@slideshare.net(SQLRich) Investigate SQL Server Memory Like Sherlock Holmes SQLRich Memory is one part of the holy trinity of resources consumed by SQL Server, the others being CPU and disk. Most people know how to look at disk latency and throughput and then take remedial measures to fix those issues. But what about memory issues? In this session, you will learn how SQL Server uses memory and various caches, how to gauge memory pressure, and how to address the significant problems it can cause. You will leave with a much clearer understanding of how to monitor and manage memory consumption within SQL Server using native Dynamic Management Objects. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlkonferez2020-sentryone-memory-200522125354-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Memory is one part of the holy trinity of resources consumed by SQL Server, the others being CPU and disk. Most people know how to look at disk latency and throughput and then take remedial measures to fix those issues. But what about memory issues? In this session, you will learn how SQL Server uses memory and various caches, how to gauge memory pressure, and how to address the significant problems it can cause. You will leave with a much clearer understanding of how to monitor and manage memory consumption within SQL Server using native Dynamic Management Objects.
Investigate SQL Server Memory Like Sherlock Holmes from Richard Douglas
]]> 284 0 https://cdn.slidesharecdn.com/ss_thumbnails/sqlkonferez2020-sentryone-memory-200522125354-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Investigate TempDB Like Sherlock Holmes /slideshow/investigate-tempdb-like-sherlock-holmes/59672363 investigatetempdb-160317105352
The SQL Server system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affect everybody on that instance.]]>
The SQL Server system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affect everybody on that instance.]]> Thu, 17 Mar 2016 10:53:52 GMT /slideshow/investigate-tempdb-like-sherlock-holmes/59672363 SQLRich@slideshare.net(SQLRich) Investigate TempDB Like Sherlock Holmes SQLRich The SQL Server system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affect everybody on that instance. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/investigatetempdb-160317105352-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> The SQL Server system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affect everybody on that instance.
Investigate TempDB Like Sherlock Holmes from Richard Douglas
]]> 2592 8 https://cdn.slidesharecdn.com/ss_thumbnails/investigatetempdb-160317105352-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Understanding the Transaction Log, Your Key to Unlocking Greater Throughput /SQLRich/understanding-the-transaction-log-your-key-to-unlocking-greater-throughput understandingthetransactionlog-151015141834-lva1-app6892
Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. ]]>
Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. ]]> Thu, 15 Oct 2015 14:18:33 GMT /SQLRich/understanding-the-transaction-log-your-key-to-unlocking-greater-throughput SQLRich@slideshare.net(SQLRich) Understanding the Transaction Log, Your Key to Unlocking Greater Throughput SQLRich Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/understandingthetransactionlog-151015141834-lva1-app6892-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There&#39;s no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log however is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It&#39;s as if it doesn&#39;t matter, an afterthought, a relic of the platform architecture. In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Understanding the Transaction Log, Your Key to Unlocking Greater Throughput from Richard Douglas
]]> 1051 4 https://cdn.slidesharecdn.com/ss_thumbnails/understandingthetransactionlog-151015141834-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Understanding indices /slideshow/understanding-indices/53976468 sqlsentry-understandingindices-151015140604-lva1-app6891
In this session you will learn more about how indexing can aid performance in SQL Server]]>
In this session you will learn more about how indexing can aid performance in SQL Server]]> Thu, 15 Oct 2015 14:06:04 GMT /slideshow/understanding-indices/53976468 SQLRich@slideshare.net(SQLRich) Understanding indices SQLRich In this session you will learn more about how indexing can aid performance in SQL Server <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlsentry-understandingindices-151015140604-lva1-app6891-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> In this session you will learn more about how indexing can aid performance in SQL Server
Understanding indices from Richard Douglas
]]> 655 4 https://cdn.slidesharecdn.com/ss_thumbnails/sqlsentry-understandingindices-151015140604-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 SQLBits XIV - The Big Backup Theory /slideshow/sqlbits-xiv-the-big-backup-theory/45663296 sqlbitsxiv-thebigbackuptheory-150310103048-conversion-gate01
In this session, you'll gain invaluable guidance for optimizing your backup strategies. Actually that is a lie, I will be advocating the mind shift from backup strategies and the devastating affect they can have on a company and instead move you to thinking about implementing restore strategies. Things become much simpler when you consider the purpose of a backup, and the effects of the different recovery models and backup options have on your customers and effectively your livelihood. Using trace flags the session will also cover how SQL Server manages its own backup options and how you can tune them to make sure that you meet the time constraints of your enforced maintenance windows.]]>
In this session, you'll gain invaluable guidance for optimizing your backup strategies. Actually that is a lie, I will be advocating the mind shift from backup strategies and the devastating affect they can have on a company and instead move you to thinking about implementing restore strategies. Things become much simpler when you consider the purpose of a backup, and the effects of the different recovery models and backup options have on your customers and effectively your livelihood. Using trace flags the session will also cover how SQL Server manages its own backup options and how you can tune them to make sure that you meet the time constraints of your enforced maintenance windows.]]> Tue, 10 Mar 2015 10:30:48 GMT /slideshow/sqlbits-xiv-the-big-backup-theory/45663296 SQLRich@slideshare.net(SQLRich) SQLBits XIV - The Big Backup Theory SQLRich In this session, you'll gain invaluable guidance for optimizing your backup strategies. Actually that is a lie, I will be advocating the mind shift from backup strategies and the devastating affect they can have on a company and instead move you to thinking about implementing restore strategies. Things become much simpler when you consider the purpose of a backup, and the effects of the different recovery models and backup options have on your customers and effectively your livelihood. Using trace flags the session will also cover how SQL Server manages its own backup options and how you can tune them to make sure that you meet the time constraints of your enforced maintenance windows. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlbitsxiv-thebigbackuptheory-150310103048-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> In this session, you&#39;ll gain invaluable guidance for optimizing your backup strategies. Actually that is a lie, I will be advocating the mind shift from backup strategies and the devastating affect they can have on a company and instead move you to thinking about implementing restore strategies. Things become much simpler when you consider the purpose of a backup, and the effects of the different recovery models and backup options have on your customers and effectively your livelihood. Using trace flags the session will also cover how SQL Server manages its own backup options and how you can tune them to make sure that you meet the time constraints of your enforced maintenance windows.
SQLBits XIV - The Big Backup Theory from Richard Douglas
]]> 833 1 https://cdn.slidesharecdn.com/ss_thumbnails/sqlbitsxiv-thebigbackuptheory-150310103048-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Wait Watchers�; Gain SQL Performance Increases Fast! /slideshow/wait-watchers-2/45663072 waitwatchers2-150310102638-conversion-gate01
We're all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided). In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions on which areas of your environment to tune to greater effect. After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall performance for all of your users.]]>
We're all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided). In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions on which areas of your environment to tune to greater effect. After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall performance for all of your users.]]> Tue, 10 Mar 2015 10:26:37 GMT /slideshow/wait-watchers-2/45663072 SQLRich@slideshare.net(SQLRich) Wait Watchers�; Gain SQL Performance Increases Fast! SQLRich We're all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided). In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions on which areas of your environment to tune to greater effect. After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall performance for all of your users. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/waitwatchers2-150310102638-conversion-gate01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> We&#39;re all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided). In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions on which areas of your environment to tune to greater effect. After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall performance for all of your users.
Wait Watchers ; Gain SQL Performance Increases Fast! from Richard Douglas
]]> 813 4 https://cdn.slidesharecdn.com/ss_thumbnails/waitwatchers2-150310102638-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Natural Born Killers, Performance issues to avoid /slideshow/natural-born-killers-performance-issues-to-avoid/31360330 relay-naturalbornkillersperformanceissuestoavoid-140218165502-phpapp01
SQL Server is now a mature RDBMS platform. In this session Richard Douglas walks through a number of areas of the product that are misused or misunderstood. The session promotes good table and index design as well as when to use temporary tables and table variables.]]>
SQL Server is now a mature RDBMS platform. In this session Richard Douglas walks through a number of areas of the product that are misused or misunderstood. The session promotes good table and index design as well as when to use temporary tables and table variables.]]> Tue, 18 Feb 2014 16:55:02 GMT /slideshow/natural-born-killers-performance-issues-to-avoid/31360330 SQLRich@slideshare.net(SQLRich) Natural Born Killers, Performance issues to avoid SQLRich SQL Server is now a mature RDBMS platform. In this session Richard Douglas walks through a number of areas of the product that are misused or misunderstood. The session promotes good table and index design as well as when to use temporary tables and table variables. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/relay-naturalbornkillersperformanceissuestoavoid-140218165502-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> SQL Server is now a mature RDBMS platform. In this session Richard Douglas walks through a number of areas of the product that are misused or misunderstood. The session promotes good table and index design as well as when to use temporary tables and table variables.
Natural Born Killers, Performance issues to avoid from Richard Douglas
]]> 1031 4 https://cdn.slidesharecdn.com/ss_thumbnails/relay-naturalbornkillersperformanceissuestoavoid-140218165502-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 https://cdn.slidesharecdn.com/profile-photo-SQLRich-48x48.jpg?cb=1747232226 Richard Douglas is a Microsoft Certified SQL Server professional with a broad IT knowledge interested in all aspects of SQL Server including: Database design Query optimisation Business Intelligence Migration projects Disaster Recovery / High Availability Security Richard's current role is with SQL Sentry, a leading provider of SQL Server solutions where he provides advice on SQL Server solutions and delivers healthchecks to EMEA based customers. He also evangelises SQL Server via webcasts as well as at local, national and international events. Richard has been working with databases since 1996 starting with Unidata where he was an analyst/developer working for a direct marketing compa... SQL.RichardDouglas.co.uk https://cdn.slidesharecdn.com/ss_thumbnails/sqlkonferez2020-sentryone-memory-200522125354-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/investigate-sql-server-memory-like-sherlock-holmes/234468327 Investigate SQL Server... https://cdn.slidesharecdn.com/ss_thumbnails/investigatetempdb-160317105352-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/investigate-tempdb-like-sherlock-holmes/59672363 Investigate TempDB Lik... https://cdn.slidesharecdn.com/ss_thumbnails/understandingthetransactionlog-151015141834-lva1-app6892-thumbnail.jpg?width=320&height=320&fit=bounds SQLRich/understanding-the-transaction-log-your-key-to-unlocking-greater-throughput Understanding the Tran...