Thursday, June 15, 2006 - Posts

Do you do perform load testing in Live - Microsoft do

Well Microsoft.com do.

I mentioned the Tech Ed webcasts a few days ago. I unfortunately only caught the end of the Microsoft.com webcast. Well I've just finsihed watching the on demand version and wow. I previously highlighted a talk about amazon.com (Are you running a high volume website) this is another webcast that you should watch.

Its a great insight into what needs to be done to run a high end internet operation. The numbers they are talking about are just scary, 120Gigabits/sec bandwidth, ok so many sites won't be needing this level of scale. However they do provide some great points on,

  • Load balancing, NLB v hardware
  • SQL HA solutions, Peer to Peer, Mirroring, log shipping
  • Clustering
  • Global Load balancing

On interesting statement was on testing. I agree that it is very difficult to simulate Live usage, for 3 reasons, generating the amount of traffic is difficult, generating the traffic in a realistic manner is even more difficult, finally can you afford to duplicate your live hardware. So there is a valid reason for doing load testing in a Live environment.

Cross posted from http://sqlblogcasts.com/blogs

posted Thursday, June 15, 2006 6:58 PM by SimonSabin with 0 Comments

Timeout Bug with Bulk Copy and SQL Server

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Timeout Bug with Bulk Copy and SQL Server
The new RSS feed is here

I noticed with SQL Server Integration Services if I use the SQL Server Destination and my data flow doesn't provide rows quick enough to the destination a timeout can occur. Bill has blogged about a FIX for a similar issue in .Net that refers to ADO adn SqlBulkCopy.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Timeout Bug with Bulk Copy and SQL Server

posted Thursday, June 15, 2006 7:31 PM by SimonSabin with 0 Comments

How banks can steal your money

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How banks can steal your money
The new RSS feed is here

If you ever visit the forums you will learn many ways to manage your SQL Server. Some of these are good some of them not so good. Some may result in your bank stealing your money if they followed these procedures.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How banks can steal your money

posted Thursday, June 15, 2006 7:13 PM by SimonSabin with 0 Comments

SSIS Tips and Tricks - Copying components

If you want to re-organise your package by seperating a data flow into multiple data flows. Then you are better to copy the data flow task and remove the components in the flow you don't want rather than creating a new data flow task and copying the components between the data flows.

Why is that?

Well the main reason is that copying components results in components having numbers appended i.e. "lookup" becomes "lookup 1", which is very annoying

Cross posted from http://sqlblogcasts.com/blogs

posted Thursday, June 15, 2006 5:11 PM by SimonSabin with 0 Comments