Hello,
I read that is there is this Database setting for service broker: ERROR_BROKER_CONVERSATIONS
I have not understood the how to use this setting in real scenario.
Could somebody provide me some practical example?
White papers are also ok! :-)
Thank you
Marina B.
Can anyone tell me the practical use of ACID properties. I know theory available in books. But where it will implement practically I am confused.
View 8 Replies View RelatedWe are primarily a DB2 and Oracle shop. There are movements towards SQL Server for smaller applications. We would like to know if anyone out there has shop standards in determining which database should go with what type of application. What we are looking for are possibly database sizes, number of concurrent users, hardware and software cost, network infrastructure, security, scalability, and development tools. Any information would be appreciated.
View 1 Replies View RelatedHi all,I'm looking for some ball park estimates on when SQL Server might startto break down, and can't find any reliable info. Any insight is appreciated.Basically, the situation is this: The database structure is very simple;just one table with about 15 columns and about 60-75 million rows. There'sno need for massaging data or complex relations, just simple searches onmaybe a max of 5 columns. Out of the gates we'll be looking at having 30concurrent users and rapidly expanding to about 300-400 concurrent users.I might need to rebuild the database on a daily or weekly basisdepending on how often changes are made to a master file. In the past I'vebeen bit in the butt with the absolute crappiness of SQL Server'sreplication, so I'm going to try to avoid that path if I can (plus I alreadyhave some scripts written to delete and rebuild a similar database on anightly basis). Would it be practical to destroy and rebuild a database thissize on a daily basis?The big question is if searching 60-75 million records is practical inSQL server. If so, what kind of machine would I need to get a nearly instantresponse time per search (.2 second or so) when everyone's banging on it atonce? How many concurrent users can I expect to be able to practicallysupport before SQL Server will start to bog down? Thanks for your thoughts,-Ringo
View 3 Replies View RelatedHi,
is there any website or book that provide excellent database design examples to learn?
Appreciate for any help
Ricky.
I Want to test for Automatic switch between primary and secondary.
How do i do it ?
or
I need this for some purpose : How to set suspect mode for a database ?
Our development team wanted to create a database user for each application user in the application and use these for granular data access control, which at first, sounded like a good idea but our initial testing ran into some interesting results.
Our target user base was about 15 million users with an estimated 1% concurrency rate, and finding no MS documentation on an upper limit to the number of users a database can have we began some load testing to see how the database performed. In the hundreds of thousands of users range our test database had a hard time performing well under light loads (even without any concurrent connections).
When we purged the users and reverted back to just a handful of service accounts, performance went back to "normal" under the same loads. I began to wonder if this is a situation where throwing more hardware at the problem would overcome the issue or if there is a practical upper limit to the number of users a single database can handle well.
(There were of course other cons to this arrangement and I certainly was never going to expand the users tree in the object explorer for a database like this, but we thought it a solution worth investigating.)
What is the largest number of users any of you have had in a single database?