SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How do i Load database server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vivekshah
Starting Member

India
1 Posts
Posted - 05/31/2006 :  01:21:02  Show Profile  Reply with Quote

Hello friends

Is there any method/solution so that i can externally load the databse.

I need it for the project i am currently working on.
it comprises of some online restaurant, that has one central database server & all the restaurant acces this server for evry single request they fire.

BUT during weekends the server has tremendous load.

So any idea how do i load the database server?
any query/procedure or any idea?

Thanx in advance



Vivek

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts
Posted - 05/31/2006 :  01:39:20  Show Profile  Send jen a Yahoo! Message  Reply with Quote
what do you mean by load?
attach it to the server or restore a backup file?



--------------------
keeping it simple...
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts
Posted - 05/31/2006 :  04:52:31  Show Profile  Visit mr_mist's Homepage  Reply with Quote
By load do you mean "put lots of sample usage on?"

There's a stress tool that Microsoft had a while ago.

-------
Moo. :)
Go to Top of Page

jpotucek
Constraint Violating Yak Guru

USA
272 Posts
Posted - 06/01/2006 :  13:47:47  Show Profile  Send jpotucek an AOL message  Reply with Quote
check out http://support.microsoft.com/kb/q231619/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000