Reviewing sp_sysmon Output: Task Context Switches

    By: Jeffrey Ross Garbus on Jan 01, 2014

    Data storage, data processing and data analysis has reached new levels of complexity brought about by a) our desire to action real-time insight into modern workflows b) the massively distributed and/or massively stacked nature of the computing instances that we see before us and c) a host of other conjoined factors that would make this introduction roll forward into the realms of a complete feature in its own right.

    Suffice it to say that we now need to bring new levels of intelligence to bear upon the tasks we undertake with mission-critical data sets. If some of this intelligence now focuses on areas such as tuning and the use of task context switches within procedures that may not have otherwise been augmented with these capabilities, then our future prospects may indeed look brighter. This feature takes a considered approach to the use of task context switches and looks at where users can engineer to have processes work better and smarter all round.

    As part of a balanced tuning approach, or as part of a “What in the world is going on?” exercise, you will occasionally need to examine output from the sp_sysmon stored procedure.

    While we could certainly write books on this subject (and on occasion, have), we’re going to focus on a specific area (and will continue to do this in subsequent articles).

    Login to read the article. Not a member? Create a free account!

    Released: January 1, 2014, 3:55 pm | Updated: April 22, 2014, 2:35 pm
    Keywords: ASE DBA Article | Technical Journal | Alvin Chang | ASE | Jeff Garbus | Lyle Fernquist | Performance & Tuning | sp_sysmon




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk