|
Lot's of stuff going on now, we have an event tonight (24th) in Reading and also one on the 29th Nov again in Reading, we are working on other venues - we are planning one in Scotland for January and need people to send us topic suggestions - please email Martin Bell, SQL Server MVP; I'm also presenting on the 1st November in Oxford repeating the session I did at the VBUG conference.
I've been doing a lot of cluster work of late, building 2005 HA environments, one specific client we are using an EMC CX300 and having really big problems getting good performance on log writes, a write to the log is done in chunks of 512bytes to 64KBytes and the SAN just can't handle these small IO's very well; I expand in a blog entry how to go about seeing what transaction log throughput you get from your kit - extremely important because writing to the log is critical for a well performing and scalable system.
Don't forget to check out the events section, some good, albeit a bit BI orientated but I'll fix that; check out the 2 day SQL Tuning class and the 5 day BI boot camps.
PS.. No word on SP2 beta yet and if you are on SP4 consider moving to hotfix 2187; too many problems with SP4 imho.
Tony Rogerson, SQL Server MVP
tonyrogerson@sqlserverfaq.com
24th October 2006
|
| Build a Microsoft Cluster environment for less than £17,000 |
Most work I do is for small to medium size companies, some with enterprise size systems some not; there is more interest in high availability and resilience in this domain now - not just playground of the money to burn enterprise companies. Anyway, in this post I comment on the HP MSA500 packaged cluster and what you can build for < £17K.
An average system (7 x 146GB disks, 4 in RAID 10, 2 in RAID 1 and 1 hot spare, 5GB of RAM) costs.....
Link to blog entry
|
| SQL Server 2005 Rebuilding Indexes |
| Simon Sabin talks about problems he's had rebuilding indexes and performance reasons for doing so when upgrading.
Link to blog entry
|
| Server Commissioning Part #1 - Transaction Log and Performance |
| For any write activity to the database the write performance to the transaction log is critical. If you have high latency on writing to the transaction log then your process will be slow. This article comes from problems Tony Rogerson has had building a cluster using the EMC CX300 and some must knows when building and trialling your kit.
Link to blog entry
|
| Comments on the UPDATE statement |
| What's best? Specify only the columns you are updating or does it matter?
Link to blog entry
|
| About the Group, UK's biggest SQL Server community |
|
The group has nearly 9,500 members in the UK, the site holds over 900,500 news group posts, has over 300 distinct daily visitors generating in excess of 3,000 sessions. The site holds a growing number of short video demonstrations on SQL Server that can be viewed in Media Player.
We are one of the CodeZone Federated Search members, you will see us in the help system built into Visual Studio 2005 and SQL Server 2005—we made it into the product, my work is done :-)!
The group was founded in 1998 and is still run by Tony Rogerson who has been awarded SQL Server MVP (Most Valued Professional) for 8 years running, as well as running the group his day job is an Independent SQL Specialist/Consultant.
|