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 » performance » Tools   (RSS)
Showing page 1 of 2 (15 total posts)
  • New White Paper: SQL Server Extended Events and Notifications

    SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As ...
    Posted to Kevin Kline (Weblog) by KKline on April 25, 2012
  • SQL Live Monitor

    I just found this one out there and wanted to share it. It connects to an instance and show you a bunch of figures. Nothing you can't extract yourself with SQL queries, but sometimes it is just nice to have one tool which is very easy to use. Here's what it looks like when connecting to an instance with no load on it: As you can see, there ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 19, 2011
  • Microsoft Windows Platforms Blog Watch

    Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
    Posted to Kevin Kline (Weblog) by KKline on July 20, 2011
  • From SQLMag Tool Time Column: SSMS Plug-in News

    I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having. If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the ...
    Posted to Kevin Kline (Weblog) by KKline on May 12, 2011
  • Database Maintenance Scripting Done Right

    I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2011
  • Have You Heard About Project Lucy?

    Lucy, You Got Some 'Splainin to Do!' Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia ...
    Posted to Kevin Kline (Weblog) by KKline on February 16, 2011
  • 2009: The Year in List Form

    Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter), I decided I'd spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00's were my most difficult decade yet.  Major problems of every stripe beset me on all sides and with alarming frequency throughout ...
    Posted to Kevin Kline (Weblog) by KKline on January 5, 2010
  • New Post on my SQLMag Blog – Free DMV Monitoring Tools

    I’ve posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex.Read the article here:http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1Take a look at the two tools and let me know which you like better and why.  Inquiring minds want to know!Cheers,-Kevin Twitter ...
    Posted to Kevin Kline (Weblog) by KKline on September 18, 2009
  • Automating Query Exec, Index Usage and Execution Plans, Update 2

    I have made updates to my tool for automating SQL Server query exec stats, index usage, execution plan analysis. So I would like people to give it a try and send feedback. If there is an error, please report the file and line number (the top level is sufficient). download at http://www.qdpma.com/tools/ExecStats.zip (check ...
    Posted to Joe Chang (Weblog) by jchang on July 13, 2009
  • Match those types!

    This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the column side - not the literal side of your query. What does that mean? Consider below: WHERE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 28, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement