Search Results

Search found 890 results on 36 pages for 'jonathan k'.

Page 5/36 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• An XEvent a Day (3 of 31) – Managing Event Sessions

  - by Jonathan Kehayias

  Yesterdays post, Querying the Extended Events Metadata , showed how to discover the objects available for use in Extended Events.  In todays post, we’ll take a look at the DDL Commands that are used to create and manage Event Sessions based on the objects available in the system.  Like other objects inside of SQL Server, there are three…

  Read the article

• Did the Community Lose It’s Focus, or Did I?

  - by Jonathan Kehayias

  Late Thursday night, ok it was actually very early Friday morning, I wrote a blog post that stirred a bit of a controversy in the community.  While the outcome of the discussion that was sparked by that post in the community has been good, it is definitely a case where the end isn’t justified by the means.   Hindsight is always…

  Read the article

• An XEvent a Day (5 of 31) - Targets Week – ring_buffer

  - by Jonathan Kehayias

  Yesterday’s post, Querying the Session Definition and Active Session DMV’s , showed how to find information about the Event Sessions that exist inside a SQL Server and how to find information about the Active Event Sessions that are running inside a SQL Server using the Session Definition and Active Session DMV’s.  With the background…

  Read the article

• An XEvent a Day (15 of 31) – Tracking Ghost Cleanup

  - by Jonathan Kehayias

  If you don’t know anything about Ghost Cleanup, I recommend highly that you go read Paul Randal’s blog posts Inside the Storage Engine: Ghost cleanup in depth , Ghost cleanup redux , and Turning off the ghost cleanup task for a performance gain .  To my knowledge Paul’s posts are the only things that cover Ghost Cleanup at any level…

  Read the article

• An XEvent a Day (14 of 31) – A Closer Look at Predicates

  - by Jonathan Kehayias

  When working with SQL Trace, one of my biggest frustrations has been the limitations that exist in filtering.  Using sp_trace_setfilter to establish the filter criteria is a non-trivial task, and it falls short of being able to deliver complex filtering that is sometimes needed to simplify analysis.  Filtering of trace data was…

  Read the article

• An XEvent a Day (17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)

  - by Jonathan Kehayias

  Today’s post is a continuation of yesterday’s post How Many Checkpoints are Issued During a Full Backup? and the investigation of Database Engine Internals with Extended Events.  In today’s post we’ll look at how Backup’s work inside of SQL Server and how to track the throughput of Backup and Restore operations.  This post is…

  Read the article

• RK4 Bouncing a Ball

  - by Jonathan Dickinson

  I am trying to wrap my head around RK4. I decided to do the most basic 'ball with gravity that bounces' simulation. I have implemented the following integrator given Glenn Fiedler's tutorial: /// <summary> /// Represents physics state. /// </summary> public struct State { // Also used internally as derivative. //…

  Read the article

• An XEvent a Day (12 of 31) – Using the Extended Events SSMS Addin

  - by Jonathan Kehayias

  The lack of SSMS support for Extended Events, coupled with the fact that a number of the existing Events in SQL Trace were not implemented in SQL Server 2008, has no doubt been a key factor in its slow adoption rate. Since the release of SQL Server Denali CTP1, I have already seen a number of blog posts that talk about the…

  Read the article

• An XEvent a Day (4 of 31) – Querying the Session Definition and Active Session DMV’s

  - by Jonathan Kehayias

  Yesterdays post, Managing Event Sessions , showed how to manage Event Sessions in Extended Events Sessions inside the Extended Events framework in SQL Server. In today's post, we’ll take a look at how to find information about the defined Event Sessions that already exist inside a SQL Server using the Session Definition…

  Read the article

• An XEvent a Day (16 of 31) – How Many Checkpoints are Issued During a Full Backup?

  - by Jonathan Kehayias

  This wasn’t my intended blog post for today, but last night a question came across #SQLHelp on Twitter from Varun ( Twitter ). #sqlhelp how many checkpoints are issued during a full backup? The question was answered by Robert Davis (Blog|Twitter) as: Just 1, at the very start. RT @ 1sql : #sqlhelp how many checkpoints…

  Read the article

• An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter

  - by Jonathan Kehayias

  Yesterday’s post, Targets Week - Bucketizers , looked at the bucketizer Targets in Extended Events and how they can be used to simplify analysis and perform more targeted analysis based on their output.  Today’s post will be fairly short, by comparison to the previous posts, while we look at the…

  Read the article

• An XEvent a Day (1 of 31) – An Overview of Extended Events

  - by Jonathan Kehayias

  First introduced in SQL Server 2008, Extended Events provided a new mechanism for capturing information about events inside the Database Engine that was both highly performant and highly configurable. Designed from the ground up with performance as a primary focus, Extended Events may seem a bit odd…

  Read the article

• An XEvent a Day (6 of 31) – Targets Week – asynchronous_file_target

  - by Jonathan Kehayias

  Yesterday’s post, Targets Week - ring_buffer , looked at the ring_buffer Target in Extended Events and how it outputs the raw Event data in an XML document.  Today I’m going to go over the details of the other Target in Extended Events that captures raw Event data, the asynchronous_file_target.…

  Read the article

• An XEvent a Day (2 of 31) – Querying the Extended Events Metadata

  - by Jonathan Kehayias

  In yesterdays post, An Overview of Extended Events , I provided some of the necessary background for Extended Events that you need to understand to begin working with Extended Events in SQL Server. After receiving some feedback by email (thanks Aaron I appreciate it), I have changed the post naming…

  Read the article

• Reinventing the Wheel – Automating Data Consistency Checks with Powershell

  - by Jonathan Kehayias

  When I started in my current position at the beginning of the year, one of the first things that I did was to schedule a sit down with the various teams of Analysts that exist in our organization to find out more about their systems.  One thing I am always interested in is the manual processes…

  Read the article

• An XEvent a Day (7 of 31) – Targets Week – bucketizers

  - by Jonathan Kehayias

  Yesterday’s post, Targets Week - asynchronous_file_target , looked at the asynchronous_file_target Target in Extended Events and how it outputs the raw Event data in an XML document. Continuing with Targets week today, we’ll look at the bucketizer targets in Extended Events which can be used to…

  Read the article

• Reinventing the Wheel – Automating Data Consistency Checks with Powershell

  - by Jonathan Kehayias

  When I started in my current position at the beginning of the year, one of the first things that I did was to schedule a sit down with the various teams of Analysts that exist in our organization to find out more about their systems.  One thing I am always interested in is the manual…

  Read the article

• gl_PointCoord always zero

  - by Jonathan

  I am trying to draw point sprites in OpenGL with a shader but gl_PointCoord is always zero. Here is my code Setup: //Shader creation..(includes glBindAttribLocation(program, ATTRIB_P, "p");) glEnableVertexAttribArray(ATTRIB_P); In the rendering loop: glUseProgram(shader_particles);…

  Read the article

• An XEvent a Day (9 of 31) – Targets Week – pair_matching

  - by Jonathan Kehayias

  Yesterday’s post, Targets Week – synchronous_event_counter , looked at the counter Target in Extended Events and how it could be used to determine the number of Events a Event Session will generate without actually incurring the cost to collect and store the Events.  Today’s post is…

  Read the article

• Don’t just P2V that server for Testing!

  - by Jonathan Kehayias

  If you use virtualization in your company, at some point in time you might be tempted to perform a Physical-To-Virtual conversion, also known as P2V.  The ability to create a complete working copy of a physical server as a virtual machine is really useful for migrating to a…

  Read the article

• An XEvent a Day (20 of 31) – Mapping Extended Events to SQL Trace

  - by Jonathan Kehayias

  One of the biggest problems that I had with getting into Extended Events was mapping the Events available in Extended Events to the Events that I knew from SQL Trace. With so many Events to choose from in Extended Events, and a different organization of the Events, it is really…

  Read the article

• An XEvent a Day (27 of 31) – The Future - Tracking Page Splits in SQL Server Denali CTP1

  - by Jonathan Kehayias

  Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages , showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events , that showed how to see the…

  Read the article

• Making Use of Plan Explorer in my own Environment

  - by Jonathan Kehayias

  Back in October 2010, I briefly blogged about the SQL Sentry Plan Explorer in my blog post wrap up for SQL Bits 7 and how impressed I was with what I saw from a Alpha demo standpoint from Greg Gonzalez ( Blog | Twitter ) while I was at SQLBits 7 in York.  To be 100%…

  Read the article

• Some thoughts on the Virtualization Feedback in the SSWUG Newsletters

  - by Jonathan Kehayias

  Last Thursday, March 25, 2010, the topic of Virtualization of SQL Server came up in the SSWUG Newsletter , with Steven Wynkoop asking if peoples perceptions and experiences have changed since the last time he covered virtualizing SQL Server.  I unfortunately missed…

  Read the article

• Some thoughts on the Virtualization Feedback in the SSWUG Newsletters

  - by Jonathan Kehayias

  Last Thursday, March 25, 2010, the topic of Virtualization of SQL Server came up in the SSWUG Newsletter , with Steven Wynkoop asking if peoples perceptions and experiences have changed since the last time he covered virtualizing SQL Server.  I unfortunately missed…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >