Hi, I am currently running a large database (1.6 million inserts a day, a
query on that once a second with heaps of aggregate functions) on a single
relatively powerful server, although it is not powerful enough!
As cost is a very large factor I am thinking about clustering. Clustering
to save money?!? hehehe I am contemplating using a singly license of SQL
Server 2000 Standard on the 'cluster controller' and then having several
other PC's connected to it running MSDE.
The concept is that applications talk to the cluser controler. On an insert
the CC sends off the data ...