Featured Article(s)
Custom SharePoint webpart property error messages
When creating webparts with properties in them to store custom data – you can never rely too much on users not making errors and typos. The best way to tell your site contributors that they have specified an invalid webpart property is to display error message right there is a webpart tool pane – here is how …
SQL Server Best Practices Learn All About Them Here
If you haven’t seen the SSWUG.ORG Virtual Conference yet, take a look here. We’re bringing 75 sessions of content directly to your desktop. This isn’t what you may have seen called a "virtual conference" other places – this is more like TV to your desktop, focused on SQL Server, Business Intelligence and it even includes SharePoint and .NET how-to information. See the presenter, see the demos very clearly, learn what’s really important and have fun doing it! No travel budget required, no time out of the office, but the world’s best presenters. Get more information here and get registered today – it’s coming up October 21, 22 and 23.
Webcast Tomorrow – Register Now
Processing Late Arriving Facts with Integration Services
Handling late arriving facts and performing historical loads are common tasks in Data Warehousing scenarios. This webcast takes a look at the pros and cons of three different approaches to this problem using SSIS. Presented by: Matt Masson
> Register Now
> 9/30/2009 at 12:00pm Noon Pacific
Trending for Your SQL Server – Are You Doing It?
I was talking with Kevin Kline today – talking about different tools, approaches and things he sees "out there" in the field. We talked briefly about trending and it got me thinking about the types of things you pay attention to – from disk space to CPU utilization, etc.
I have gone through this in webcasts with Performance Monitor and in classes, specifically figuring out what best outlines what your servers are doing, then monitoring that to determine a baseline today, then a baseline at regular intervals going forward. If you use this information, you can determine trends of usage on your systems on these key items and use this to see when you’ll need to add disk space, add CPU, split server or whatever your growth strategy is.
My question to you is pretty straightforward. What items do you monitor?
Here’s my shortlist:
– Disk space (ALL drives)
– CPU utilization – averaged, across spikes, with a nod to the maximum values
– RAM
– Buffer cache hit ratio
What items do you monitor? If you don’t monitor, do you do trending another way, or just pay attention to how the system is performing on a subjective level? How do you tell when it’s time update/upgrade before you hit the wall?
Please drop me an email here – let me know what works for you (or doesn’t work for you).
Ever had to spend hours restoring a backup file just to perform a 5-minute task? What a pain! Now there is a better way – Idera has just announced a public beta of a new product called SQL virtual database. SQL virtual database allows you to attach a backup file to SQL Server as a virtual database, giving you instant access to data in backup files without restoring! Try the SQL virtual database beta and send Idera feedback and you’ll be entered to win one of five netbooks!
Featured White Paper(s)
Managing Complex Database Changes
Development can be a volatile endeavor – especially when sites or applications are database dependent and subject to a high d… (read more)