I tried most of the suggestions given here including changing memory settings and account permissions. Since last friday when we rebooted the machine, the performance has been acceptable since users...

Just to add to my previous info, while looking in to the SQL Logs I found the following type messages

Unsafe assembly 'microsoft.sqlserver.mpusqlclrwrapper, version=10.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil' loaded into appdomain 4...

You should not try to restore system databases unless there is a crisis.

I was suggesting 3-4 logical drives in possibly raid 10 config. One external raid controller should be fine for this. But this increases the cost for sure.

I have seen environments...

When you restore database to a different server your Database users are orphaned.

use databasename

EXEC sp_change_users_login 'Report'

If you already have logins created in the new server then use

use databasename

EXEC sp_change_users_login...

5 million records (50 lakhs) is not a huge number. There may be other reasons the queries are slow. Create new index during non peak time.

It would depend on how many users you have for the application and the kind of reports that you will be running. Since it looks like a reporting database you...

While looking through the SQL logs I found that there is message "Cannot use large page extensions. lock memory privilege was not granted".

I thought for 64 bit systems this...

Friends Thank you for the suggestions.

When I set the max memory to 26 gig, I did take into consideration the memory required by the threads ( I assumed the number...

I have set the min memory to 8 gig and max to 26 gig. It is a 64 bit machine.

Also this machine is 24 core. It was one of the...

Hi,

I have more to add to my previous post. I looked into my error logs and found this error msg."Failed to map 16777216 bytes of contiguous memory". This message is...

No. I am suing datetime at both the places. I am wondering if SQL server is supposed to give error when it gets more than 3 digits milliseconds or is...

Thanks 456789psw.

Thanks Derrick.

I made an observation, whenever the sql server memory usage reaches 100% the page life expectancy drops to couple of hundreds and stays there for a long time. Is...

You can try to narrow down your profiler for specific database or specific table or specific stored procedure. Also I have read some time back that using t-sql for tracing...