Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 [resolved]

Author  Topic 

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-03 : 05:37:14
resolved

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-04-03 : 09:31:51
What is the size of database(s)? What transaction /sec or batch request/sec are expected?
Both technologies have their own ups and downs so weigh both options and see which one outperforms other.
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-03 : 10:15:49
resolved
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-04-03 : 11:22:22
Active/Active clusters require shared storage of sometype. You may be able to use replication or possibly Log shipping.
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-06 : 04:32:52
resolved
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-04-06 : 12:38:55
Not to discourage you,

http://msdn.microsoft.com/en-us/library/ms190202.aspx

is pretty thorough for SQL.

Active / Active is specifically a Cluster term. I know for a fact you cannot use a cluster w/o shared storage. You may be able to emulate shared storage with software or in a virtual environment, but performance would decrease in that case.

There are several othe ways to have 2 active sql nodes with identical data. I looked into using database mirroring. But as we generate dozens of new applications and databases a week it would be unrealisitic in terms of recoding old work.

Is the active / active requirement based on performance or reliability.


Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-07 : 04:35:42
resolved
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-04-07 : 14:17:38
I use NTLBS for my IIS, I really like the way it works.
It will provided HARDWARE failover (is crashed server)

I really only see DB Mirroring as an option w/o the shared storage. If you need the CPU resources of both machines, you could setup two instances, A Principal / Mirror B Mirror / Principal

Someone who has implimented mirroring would have to confirm if there would be any performance advantage to that.
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-08 : 04:15:52
resolved
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-21 : 05:26:53
Thanks for not letting other users benefits from same help as you got.
quote:
04/03/2009 : 05:37:14
I've been asked to set up a new configuration which is far from ideal. Two new fairly high spec servers with windows server 2008 and SQL Server 2008. Here is requirement:

1. high availability / redundancy without purchasing a SAN.
2. utilise one of the servers as a test machine - so Active/Active needed if clustering used.
3.SQL Server and IIS on same machine so webpages connect to DB's using (local). - this requirement I hope to get dropped but I throw it in for now.

Is clustering an option or is mirroring a preferred route?

quote:
04/03/2009 : 10:15:49
mdf file sizes: largest 10GB and growing by about 2GB every month, and another 8 db's fairly constant under 250MB. All have fairly low transaction /sec with a maximum of about 3000 per sec per db, but usually much lower.

My main question - is it veasable to have Active / Active clustering without a SAN?

quote:
04/06/2009 : 04:32:52
Tripodal - thanks for the reply.
I know it's normal practice but I've found a few references to Active/Active being possible without shared storage in sql server 2008. But I really need a little more details as to how it's done and what are the pros and cons.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24083832.html

quote:
04/07/2009 : 04:35:42
Tripodal - cheers for that.

The main reason for Active/Active is to give access to the second node's resources - it's harddisk space and it's processor power. Eg. as a test machine, or to have one node as main IIS / application server and one node as main db server, also - possibility of running reporting services from a seperate node - but with the possibility of either node carrying out all duties if a single node goes down.

Can you confirm these are my options?
1. Active/Active Cluster with additional shared storage - second node's resources become available
2. Active/Passive Cluster with no additional shared storage - second node's resources not available
3. Mirroring with no additional shared storage - each server is standalone so it's resources available but no automatic failover


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-21 : 11:28:00
Peso - I deleted my comments not Tripodal's help. I have a reason why I wanted to remove my question which I would rather not have to justify. I would appreciate it if you can delete the post you got from google cache.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-21 : 11:33:21
Other users can't benefit from Tripodals answers if they don't know the questions.
If you want private help, pay a consultant.

This forum has help provided for free, from people sharing their knowledge and time for nothing.
Also, there is nothing specific in your questions revealing anything about you or your company.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-21 : 11:45:10
I know I haven't contributed to the same extent to this forum as yourself and others but I also give time to try to help users of the site. I don't think its fair to imply that I only want to help myself. The is the only time I have deleted a question.
Tripodal helped me and I thanked him - I don't see what it has to do with you.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-21 : 11:54:44
You can have a chat with moderators or site operator.
If they decide to, they can edit my post.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-04-21 : 12:03:39
no the post won't be removed. there's no point to it anyway since it's already stored in google cache.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-04-21 : 12:10:54
I agree with keeping it. How would you feel if someone with your exact same problem posted it earlier, but removed all the details that would have helped you solve it immediately?

If you really can't let this information be on a public forum, don't post it in the first place.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-21 : 13:01:15
I agree with Mladen and Rob, so I won't be deleting the topic either.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-22 : 04:38:12
Firstly Google cache is temporary - google says it is refreshed usually around every 3 days, secondly not every user knows about Google cache. Most importantly - according to this site's FAQ

"Editing Your Posts
You may edit or delete your own posts at any time. Just go to the topic where the post to be edited or deleted is located and you will see a edit or delete icon .... No one else can edit your post, except for the forum Moderator or the forum Administrator."

One rule for average user another for "Super-user" Peso?
Who has ownership of my words, Peso or me? For instance if one user of this site decides to copy all of Peso's answers and make a book of them - would Peso object?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-22 : 04:40:12
Only if they don't atttribute the code to me.
For those who want to read more about my code and algorithms, here is my blog
http://weblogs.sqlteam.com/peterl/



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-22 : 04:42:17
quote:
Originally posted by darkdusky

Firstly Google cache is temporary - google says it is refreshed usually around every 3 days, secondly not every user knows about Google cache.
Well, I found your text 18 days after original post.

I think Google caches text for 6 months.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-04-22 : 04:44:34
acctually the words are public domain. if a user decides to reply quoting your post then it's considered his post.

if it were a book that would be sold that would be questionable. if it were free he'd have no basis for objection.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -