Operations Manager Management Pack Development Kit I just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit. Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel. But I digress... So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007. It provide the you with all of the info need to design and build a management pack … [Read more...]
Build Your Own Microsoft Operations Manager Pack
Filed Under: Challenges, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Monitoring, Performance
Give A Round of Applause for Microsoft System Center!
I hope you've taken a few minutes to peek in on the nice refresh that's happened on a bunch of the System Center engineering blogs. Good things are afoot there. And if you haven't checked in, avail yourself of these great resources: System Center: Service Manager System Center: Operations Manager System Center: Virtual Machine Manager System Center: Orchestrator System Center: Data Protection Manager And, as always, I'm interested in your feedback. Tell me what you think! Enjoy, -Kevin Follow me on Twitter! … [Read more...]
Filed Under: Cool Technologies, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Monitoring
New White Paper: SQL Server Extended Events and Notifications
Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues 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 database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]
Filed Under: Administration, Challenges, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, Tips & Tricks Tagged With: Best Practices, DBA, Internals, Monitoring, SQL Server 2008 R2
Microsoft SQL Server Internals & Architecture Matter!
EPIC FAIL! This was supposed to go out last week. But I didn't schedule it properly, so I'd just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below. Plus, my session will be available via streaming by the end of the week. And thanks the the 1600 folks who registered! -=-=-=- Come join me on Tuesday, August 2, 2011 11:00 AM - 12:00 PM EDT for a free webcast covering the internals and architecture of Microsoft SQL Server. It's not everyday that a dry topic like this is presented in a fun and easy to … [Read more...]
Filed Under: Administration, Databases, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, Developer, Internals, Monitoring, Performance, SQL Server 2008 R2
Available Online – SQL Server Training Videos
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE. Enjoy! -Kev ~~~ Twitter at kekline More content on my Blog … [Read more...]
Filed Under: Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2008 R2, Video
New on SQLMag.Com: Update to SP_WHOISACTIVE
I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time. Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column. Enjoy! -Kev Twitter at kekline … [Read more...]
Filed Under: SQL Server, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Internals, Monitoring, SQL Server 2008 R2, SQLMag, Tools, Tools & Scripts
Video: Where are good SQL Server resources?
Kevin discusses resources online that he uses and considers to be excellent destinations for SQL Server professionals. Kevin will discuss each site he uses in detail - check it out! Posted August 15, 2008. … [Read more...]
Filed Under: Databases, On-Line Resources, Presentations, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Developer, Internals, Monitoring, SQL Server 2005, Tools, Video
Video: Ensure Optimal Performance When Deploying SQL Server 2005
Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]
Filed Under: Databases, IO, On-Line Resources, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts
Video: SQL Performance Optimization
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should. You will learn how to: * Identify the root cause of bottlenecks that hinder performance of your SQL Server environment * Diagnose and fix T-SQL errors in development before code goes into production * Learn new best practices for project planning and … [Read more...]
Filed Under: Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Quest Software, Tools & Scripts, Video
DBTA: The Big Keep Getting Bigger
In this season of recession and financial meltdowns, a common question seems to be, "How big is ‘too big to fail'?" Titans of the financial industry made big bets with lots of risk and, when they didn't pan out, American society overall has to pay the price. But, that aside, the very scale of our financial system, by just about every metric, has reached amazing heights, be that number of financial transactions per second, number of traders, number of funds traded, amount of money changing hands—you name it. [READ MORE] … [Read more...]
Filed Under: BigData, Challenges, Databases, DBTA, Hardware, IO, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Trends Tagged With: Best Practices, DBA, DBTA, Developer, Internals, Monitoring, news analysis, SQL Server 2008 R2
