Featured Article(s)
SQL Server 2005 DBCC Optimization Tips (Part 3)
In this article, you can find some helpful SQL Server 2005 DBCC performance tuning and optimization tips.
Interesting Issue of Design with SQL Server
I was reading over this post by one of our frequent email discussion list contributors, Linchi Shea – he is talking about what he’s calling SQL Storms – a great term. In this example, he’s talking about a situation with grids, but I’ve seen some other interesting things happening with some projects as well. Definitely take a look at his post (here).
What’s important to know about this is that, as more and more applications become more … responsive, we’ll see implications of this that will be challenging to track down and address. I say "responsive" because this is something we’re seeing with some AJAX-based projects in development, test and even production.
With the new abilities to query, live, back to the database and return results, update the UI, etc., you can quickly be faced with a lot more SQL Server traffic to do those interactive updates. Most of the time we’ve been able to work around this or suggest ideas for addressing the round-trip hits, but just know that you may be faced with looking at the UI implementation to really hunt down what’s hitting your server in these implementations that can, indeed, look like a denial of service-type attack.
I bring this up because you need to know that these things can be impacting your applications – not necessarily queries out of control, under-performing systems, etc. It can be a UI-implementation thing that you’ll have to track down and test to see what the updates/queries are, how you can perhaps cache or better show the information and how you can control the round trips to the database. This isn’t limited to the AJAX implementations; it’s just easy to point at that since there are so many applications using this approach these days. We’ve seen this with list box updates, grid updates, etc.
Something to think about as you work through great performance on your servers.
Video Show (SelectViews): Resume Tips, Small Business Thoughts – SQL Server
I put together some tips from the resumes I’ve been reviewing and some ideas about what people are starting to really ask frequently about in terms of setting up your own business. This is a very focused show to address some of the mass of emails we’ve been getting on this topic. [Watch the Show Here]
Previously: SelectViews Show – Special Edition!
I posted this show previously in mistake – it’s live now!
(135) SelectViews: Special – Optimizing Backup and Restore Performance – Thomas LaRock
[Watch the Show Here]
Featured White Paper(s)
SQL Server Database Backup and Restore Planning
Whether a business is small, medium or large business, it must have a well-written plan for backing up the servers. Planning … (read more)