July 28, 2006 at 1:49 am
Hai guys,
Now my real problem is that i am running sql server 2000 on a p4 desktop machine, where i have 40 users, so performance of my application goes down when users connect one by one, i have another sql server running in another machine. is there any way that i delegate the job of first server to the second one. or is that any way that i run single sql server in two machines. sorry if the whole question is wrong
July 30, 2006 at 9:21 pm
You can' delegate the job to another server or running off 2 machine.
But you can have 2 instance of SQL Server running on same machine.
Moving the database server to another powerful machine might solve your problem but is it the ultimate solution ? You should find out what is the cause of the problem. Make sure you have sufficient RAM in the machine and your query is properly tuned.
August 2, 2006 at 5:06 am
found out the problem, my processor usage is 100% and i am running on a single processor with 1 GB RAM desktop system. hai friend what is that running 2 instances of sql server, plz help me out , problem is getting serious day by day with records adding up in the tables. or what is that clustering of servers, will that solve my issue
August 2, 2006 at 4:16 pm
You need new hardware, plain and simple. A single processor desktop class machine with 1GB of memory will not get you very far as an application database server. If your processor is pegged at 100%, the only thing you can do is to either go through your application and tune indexes and queries (which may not get you much) or upgrade to a machine with more processing power. I would imagine that, since this is a desktop machine, you are more than processor bound. The disk subsystem is a vital piece in the performance of a database server and I would venture to guess that your desktop machine is operating on only it's internal disks (7200 RPM if you are lucky). Look into investing into a server class server with dual processors and a minimum of 4GB RAM with an external RAID array.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply