MY problem Is...

Move the databases to the SAN storage and make SQL Server use the new SAN storage instaed of...

M A Srinivas (6/9/2010)

---

This is a good tool for systeminfo . Do you have a tool to capture sql server information like edition,service pack, cpu affinity mask, memory configured....

I have Perfomaed a peromance monitor countor to log (Avg. Disk sec/Write,Avg. Disk sec/Read) for 8 hours and I used PAL tool to analysis the Trace and here are the...

Nils Gustav Stråbø (6/7/2010)

---

How often do you rebuild/reorganize indexes? This kind of operations will hit your disks and memory quite hard. You will see spikes in disk I/O during these...

Nils Gustav Stråbø (6/7/2010)

---

Well, yes, it seems so by the data you have provided. But you should monitor memory usage and disk I/O. Use sys.dm_io_virtual_file_stats to monitor read on write...

So far I don't know :), coz I have put my data and log files on separate drive and put Tempdb on...

based on your valubale info and step by step trace I have got this conclusion

I have a problem with Disks (Read\Write) but have no problem with Memory.please advise

what Do you mean by these number of databases on one volume

my SQL is clusterd and this SAN storage

Nils Gustav Stråbø (6/6/2010)

---

Your disk system seems slow to me. IO stalls are too high in my opinion.

How many disk volumes do you have for all these databases?

And I was...

Nils Gustav Stråbø (6/6/2010)

---

The numbers look very good. SQL Server has even got unused memory that can be used for caching. That never happens on my systems 🙂

Just keep in...

I meant the paging file is set to 0

have appended the other result above

thanks in advakce

Hi,

I have found smth here maybe related I found the page value has been set to "0", what do you think and what is the right value I should use.

I...

Nils Gustav Stråbø (6/6/2010)

---

You haven't told use if you are experiencing any problems, like slow running queries etc. High memory usage is not an indication that there is a problem,...

Thanks Guys,

so far I have 3 diffrent approch based on above replies

1--SQL Server Doesn't need such setting "Mx Memory"

2--Recommended to Set "Mx Memory Value" specially on 64x Edition

3--Rather than just...