THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » 2008 R2   (RSS)
Showing page 1 of 2 (19 total posts)
  • Extended Events did it again: monitoring Stored Procedures performance

    In the last days I  had to work quite a lot with extended events in order to deeply monitor SQL Server performance. One interesting request that came out while implementing the monitoring infrastructure, was the possibility to monitor the performance of a set of stored procedures, vital for the correct handling of an online booking ...
    Posted to Davide Mauri (Weblog) by manowar on March 19, 2013
  • Trapping SQL Server Errors with Extended Events

    One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...
    Posted to Davide Mauri (Weblog) by manowar on March 17, 2013
  • Forcing “Custom Properties” of a Data Flow Transformation to support DTS Expression

    Today I was using a 3rd Party Data Flow component that has several Custom Properties for which I need to change some of their values at runtime using a DTS Expression. To mimic the situation let’s use the “Percentage Sampling” that has two Custom Properties: Of the two Custom Properties only some (one in this case) are available also outside ...
    Posted to Davide Mauri (Weblog) by manowar on January 30, 2013
  • Power Pivot SQL Agent Job Monitor

    In the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time. There’s a lot of interesting data in MSDB database and the various sysjob tables, but the stored data is not really easy to use outside the Management Studio. Date and Time are not stored as date/time data type, there is no easy way ...
    Posted to Davide Mauri (Weblog) by manowar on January 7, 2013
  • SSAS DMVs: useful links

    From time to time happens that I need to extract metadata informations from Analysis Services DMVS in order to quickly get an overview of the entire situation and/or drill down to detail level. As a memo I post the link I use most when need to get documentation on SSAS Objects Data DMVs: SSAS: Using DMV Queries to get Cube Metadata ...
    Posted to Davide Mauri (Weblog) by manowar on May 18, 2012
  • DTLoggedExec 1.1.2008.4 SP2 released!

    I’ve released couple of hours ago the SP2 of my DTLoggedExec tool. For those who don’t know it, it’s a DTEXEC replacement, useful to execute SSIS and having logging provided right from the engine and not from the package itself. More info can be found here: http://dtloggedexec.codeplex.com/ This SP2 release add an important feature to the CSV ...
    Posted to Davide Mauri (Weblog) by manowar on February 1, 2012
  • SYS2 scripts updated (December 2012)

    I’ve updated my SYS2 scripts: Added a new script to see how much buffer cache memory is used by each database Updated the sys2.stats script in order to have only one row per statistics Updated the sys2.query_stats script to use the sys.dm_exec_plan_attributes dmv to get better information on which database was used by the cached plans ...
    Posted to Davide Mauri (Weblog) by manowar on December 12, 2011
  • SQL Server 2008 R2 Analysis Services Operations Guide

    Some members of the SQL CAT Team just released an Operations Guide for SQL 2008 R2 Analysis Services that can be found here. While I am not a SSAS person by any means this looks pretty cool and worth while for anyone who does work with it so have a look. Andrew J. Kelly
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 1, 2011
  • Spotlight session at PASS 2011 - Temporal Snapshot Fact Table

    I’m very happy to announce that my proposal for the Spotlight session I’ve been invited to deliver at PASS 2011 has been accepted! Temporal Snapshot Fact Table You are designing a BI Solution and your customer ask you to keep a snapshot of the status of all their documents (orders, insurances, contracts, bills...whatever the word ...
    Posted to Davide Mauri (Weblog) by manowar on May 29, 2011
  • SYS2 Scripts Updated – Scripts to monitor database backup, database space usage and memory grants now available

    I’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex: Project Page: http://sys2dmvs.codeplex.com/ Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732 The three new scripts are the following sys2.database_backup_info.sql sys2.query_memory_grants.sql ...
    Posted to Davide Mauri (Weblog) by manowar on February 13, 2011
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement