Last Few Days to Register
for the SQL Server 911 vWorkshop on this Friday. 5 hours of intense instruction, certificate of completion, guidebook and much more.
[Register Here]
Featured Article(s)
Inheritance in Windows Forms -Visual Studio 2005
In this article we shall understand how we can reuse FORM behaviors through Windows FORM inheritance – Visual Studio 2005
Announcement – Summer Refresher Conference
Registration is now open! We’ve brought together the best sessions of two conferences from Fall and Spring, added in an entirely new session track, live Q&A sessions daily and other goodies. This summer refresher virtual conference is your perfect opportunity to keep your skills tuned, get questions answered, network with your peers and much more – all from the comfort of your office. The early-bird rates are now in-effect – and you can save your spot today.
Head to the vConference site and get registered today!
You’ll find four disciplines – SQL Server, Business Intelligence, SharePoint and .NET Development. Great content, tips and NO TRAVEL.
Don’t forget the SSWUGvc Twitter Channel! #SSWUGvc…
SQL Server Video Program
(133) SelectViews: Proof: Chris Shaw talks to himself(!) plus interview with Paul Nielsen, Brent Ozar and Encryption. Information about the upcoming vWorkshop, tips, experiences and more.
[Watch the Show]
Previously:
[Watch] Snapshots as Backups? David Penton, Keeping Customers, Database Inventory and More
[Watch] Christopher Regan, Donald Belcham, John Welch
[Watch] Herve Roggero, Jason Strate, and TJ Belt
We’re Establishing a User Panel – Interested?
We’re looking for only about 30 people that may be interested in joining our user panel. This panel will help review some ideas, thoughts and approaches to different features here at SSWUG.ORG. Active participation will be a maximum of 1 online meeting per month to review ideas and membership and/or vConference attendance will be provided as our thanks. If you’re interested, please send a note to me here and let me know the following in order to be considered:
– Are you currently a full, paying member of SSWUG.ORG?
– Have you attended a SSWUG.ORG vConference?
– Are you a full-time or part-time database professional?
– Where are you located (Country)? Timezone?
– Do you use SKYPE?
** There are no right answers, these just help us understand how best to possibly work with you.
Performance – Some Initial Feedback
The question was – for performance, do you "throw hardware at it" or "tune it?" Send in your feedback here.
Andries: "Performance is always an issue in our environment. It was not too long ago when the entire domain was run off of generic PC not even servers.
Management has always been tight with the capital investment. I know of the large banks here that spend $100 million on IT operations. Our shop runs on less than a tenth of that.
We are constantly at logger heads with management with regard the performance of some or other system. We also have to fight with hardware vendors to get the best out of the hardware that we have available.
Fun how vendors always want you to buy more. In our case it is more storage. We know that there is an optimal threshold between the amount of data and the free space on our san and we push the absolute maximum of that limit. Management still expect to receive the same or similar IOPS from the SAN as we got in the beginning but this is always easier than said than done.
We are currently in the process of a storage refresh cycle. When we had the various vendors out 2/3 couldn’t understand why we had our databases split over so many filegroups and datafiles. When you try to explain the workings of sql to them, their eyes glaze over and lose all signs of interest in the topic.
Performance management is an Integral part of the day to day issues that we have to face. Money can make life easier but I know things about my databases that other DBA’s and their application vendors, still need to learn."
Featured White Paper(s)
Understanding and Interpreting SQL Server Performance Counters
The SQL Server database management system provides many performance counters. However, numerous explanations provided via the… (read more)