SSWUGtv
With Stephen Wynkoop
Don’t miss this episode of SSWUGtv where Stephen interviews Josef Richberg, talking about SSIS. Joseph covers common mistakes, things to know and tips – all for SSIS and SQL Server.
Watch the Show
Scheduling Tools for Windows Chron Jobs
Richard writes:
We’ve been using SQL Sentry for five years (or more). It’s one of the best tool I have found. It handles SSIS packages, SQL Agent Jobs, and windows tasks through a simple and powerful visual interface. It allows us track successes and failures, handles emails of critical and non-critical events and allows us to work monitor and schedule both SQL and non-SQL windows servers.
Editor: I’m not sure how/if people are using this in the Azure cloud. Anyone have a clue?
What’s the Fastest Disk?
Recently I have been getting frustrated with the performance of my highly disk laden SQL Server competing for resources on a shared SAN. So, I started looking to find out what the fastest disk systems and disks are available today,
Individual Mechanical Disk speeds probably won’t be getting significantly faster. We have reached physical limits where speeding up the disk any further does not provide reliable performance. Solid State Drives are continuing to evolve allowing performance to increase.
But a single fast disk is not the only thing that makes up the performance of a disk subsystem…especially in an Enterprise based system. For those of you using a SAN as you primary disk subsystem there are a lot of potential bottlenecks between your server and your data. Moreover, you often are not the sole consumer of the SAN capabilities, and it may not be configured for the best performance of your system.
For direct attached storage the answer is also not restricted to the speed of any individual disk. The speed and number of disk controllers you have along with the configuration of the drives attached makes a big difference in the actual performance metrics.
Linchi Shea has written a great blog on measuring the performance of your disk subsystem that will prove helpful if you wish to research this topic further.
Are your disk wait queue lengths too long demonstrating disk bottlenecks? Have you found solutions to your IO bottlenecks? Drop a note to btaylor@sswug.org to share with our readers.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
7 Tricks to Attending a Conference on Someone Else’s Dime
As a success and business coach, I encourage continuous learning and sharpening our skills. But with our aggressive work schedules, how does one find the time for self-study? How can one stay ahead of the next generation technology? One effective way to stay aligned with budding technology and trends is to attend IT and Computer Science Conferences. Unfortunately in today’s economy, many companies are cutting back on travel and conference expenses.
Featured White Paper(s)
All-At-Once Operations
Written by Itzik Ben-Gan with SolidQ
SQL supports a concept called all-at-onc… (read more)