Mike Levan (3/19/2009)

---

I didnt get what you are trying to say, do we really have any issues moving data between the data files. But stilli can have a downtime thats...

Mike Levan (3/19/2009)

---

Can i add a secondary(ndf) file to a production database and move half of the tables into that ndf file without anydown time.

what would be the easy way...

EdVassie (3/19/2009)

---

Please talk to your Windows support people before changing the Windows page file size. If you move away from your site standards you will not get any thanks.

Many...

peace2007 (3/17/2009)

---

peace2007 (3/16/2009)

---

by the way, I have 2 drives, shall I set the page file size for each drive to 12 GB or the total size should be 12? besides,...

peace2007 (3/16/2009)

---

I set initial size and maximum size of page file to 12GB and enabled AWE then set the max server memory to 6GB now let's see what happens when...

srimkumarp (3/16/2009)

---

i have traced the same thing in profiler it is showing queries which is takes > 2 sec.

i have tunned through DTA but performance wise same thing it is...

peace2007 (3/16/2009)

---

for page file size, there is an initial size and max size (computer properties-> advanced -> ..virtual memory) I don't know if it is the correct place to change...

John Sansom (3/16/2009)

---

If by this statement you mean that you were running...

any suggestions???

enable AWE...refer to this

http://msdn.microsoft.com/en-us/library/ms179301.aspx"> http://msdn.microsoft.com/en-us/library/ms179301.aspx

u can set the max server memory to 6 GB and leave 2 GB for OS....if there are no other application running...

srimkumarp (3/16/2009)

---

Hi All,

How can I analysis slowness from SQL Profiler.We are facing slowness issue for all application in between 10:45 am to 12 pm ;so i have traced the...

sridhar.tondapi (3/16/2009)

---

Accidently, i have deleted a record from Application and the same is deleted from DB..

But unfortunately, i have no good idea of the DB(ER DIAGRAM).

Is there anyway that i...

the page size is not set correctly. with 8 gb of ram min page size shud be...

what are the min and max server values???

also check the page file size..??

As I said earlier awe was setup with default settings and thus the max server memory was greater than the total physical memory on the system.

I also noticed that the...