| Author |
Topic |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-11-12 : 04:36:10
|
| What are the Worst Scenarios in Sql Server 2005 ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-11-12 : 08:57:55
|
| Not having a backup is the worst I can think of. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-12 : 09:46:14
|
| Dropped database, no backup.--Gail ShawSQL Server MVP |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-16 : 04:58:59
|
| with respect to the huge volume of data ? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-11-16 : 05:04:21
|
| Still not having a backup. |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-16 : 07:02:46
|
| i have the backup and the Database contains millions of Rows |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-16 : 07:06:47
|
| i have the backup and the Database contains millions of Rows |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-16 : 07:49:58
|
| Having lots of database backups, never testing their validity, and in a crisis situation finding out that they won't restore.That's worse. |
|
|
|
Pradip
Starting Member
32 Posts |
Posted - 2009-11-16 : 07:53:42
|
| I think worst scenario will be, I have taken backup I am relaxed. Someone dropped my database, knowing I have backup. Also found backup file is not restoring data.(might be corrupt not checked after backup)pradipjain |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-17 : 06:33:10
|
| please say something with respect to the speed of the Database |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 09:01:06
|
| what are you looking for? that's a pretty wide open question |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-11-17 : 09:38:53
|
quote:
Originally posted by sagitariusmzi
please say something with respect to the speed of the Database
Faster is better.CODO ERGO SUM |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-11-17 : 12:01:40
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by sagitariusmzi
please say something with respect to the speed of the Database
Faster is better.CODO ERGO SUM
Except when something goes badly wrong as it propogates faster..  |
|
|
|
Pradip
Starting Member
32 Posts |
Posted - 2009-11-18 : 00:26:04
|
| Need more explanation,I think no one could get, what you expect from us ... me too. www.silicus.compradipjain |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-18 : 01:29:49
|
| i have a Database that is well desgined (from my point of view)and well indexed and that database is going to be Live, millions of records will inserted in itWhat difficulties , the Database will face, with respect to performance, speed and every other thing that matters when the Database is Live |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-18 : 02:41:47
|
| Have you tested that well-designed, well-indexed database under load and with those millions of rows in? If not, you may find, once it's in use that it's not as well designed and well indexed as you thought, and fixing it once it's live is far harder than fixing it in development.--Gail ShawSQL Server MVP |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-11-18 : 04:19:39
|
| So GilaMonster , How could i test the Database in Developmenet,and How to put the Load on the Database ? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-11-18 : 06:40:08
|
| Create data and then just muliply it by putting it in a loop. Alternatively, get some data from the live system and change it for test purposes. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-18 : 06:46:40
|
quote:
So GilaMonster , How could i test the Database in Developmenet,and How to put the Load on the Database ?
There are lots of tools to do load testing. (generally they cost a lot of money!) It depends on the front end.For example I've used Load runner in the past to simulate thousands of simultaneous connections each one running a script which emulates what (we thought) was a typical user session.That's with a web based front end.It certainly threw up some things we never thought of -- chiefly some continual query plan recompiles due to the use of temp tables in some stored procs and other issues.Your question was way, way too vague.NB -- what Rick D said about getting the data in the first placeCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION[/red] |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-18 : 09:26:57
|
quote:
Originally posted by RickD
Create data and then just muliply it by putting it in a loop. Alternatively, get some data from the live system and change it for test purposes.
Or, if this is in development, load fake data. I like Redgate's SQL Data Generator for that. I hear (but haven't confirmed) that Quest sells a load testing tool.--Gail ShawSQL Server MVP |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-18 : 10:49:52
|
| There's also a data generator in Visual Studio Database Edition. |
|
|
|
Next Page
|
Worst Scenarios in Sql Server