Actually we don\t have a SAN, but planning to buy an HP EVA if it supports this feature. You mean if I do a snap clone or local replication on...

I'm so thankfulness of you for helping me. That's so kina you.

Some thing like what you said,

I want to have a SAN storage. 2 servers connected to it. The...

Thanks for your kind reply.

I'd seen this page before. But it has not described the process in detail. I'm looking forward for a more technical and applicable resource. I...

Thank you for all responses friends.

You gave me hints and I found 2 good resources which let me learn considerations when installing multiple instances:

http://technet.microsoft.com/en-us/library/cc917532%28printer%29.aspx

pro SQL server 2008...

Oh, Thanks for your kind replies. I should consult with a DBA or with a network admin?I'm a Network admin and need the help of a DBA.

I'm asking...

I restarted the SQL server service. So it let the RAM to get free. I tested after it. I ran a SP with "order by" commands. The CPU usage reachd...

?What do you mean by this? No issues in RAM, Disk,....

I have a powerful physical server, not virtual. 3 instances are installed on it.

I've checked the "automatically set processor affinity mask..." check box. one instance is sql 2005 and...

Mirroring is not a good solutions since it's limited to 22 DBs although It can be used in async mode in long distance.

I visited Double-Take website. But I don't...

Why do you need clustering in your project? Clustering is a solution to improve high availability. If you wanna have a highly available environment, you have many options. You should...

Hi again,

Thanks for your kind replies. they were useful. They helped me out of my problem. The high context switches rate was for I/O waits, not for CPU. When I...

You mean the book which is published by APRESS?

written by Grant Fritchey and Sajal Dam?

1-Sure,I've used perfmon and every things seemed ok, except context switches.

and also memory , but SQL always takes the memory till a process need it. goof buffer cache hit ratio...

How can I find which I/O is problematic? Is it memory which is unable to respond to paging request in a timely fashion? disk and memory delay in transfering paged...

But I/O can be anywhere. the simple I/O issue is disk speed,while we have many I/O issues.

another question is that I didn't see any wait resource showing CPU operation...