Keep in mind that MSDN is a per-user license. Only the person, to which the subscription is registered can use the software. If you have a group working...

I find that often these "Full Recovery is slower" complaints can be traced back to improperly configured or maintained systems. Often the transaction logs either are not placed in...

You're taking the wrong approach. You need to get your hands around the issue, before you throw money at a server.

Spend some time on "www.mibuso.com". You will find lots of NAV performance related information there. Along with access to people with lots of experience in this area. You...

I ran the queries suggested by Carl. They appear to support my thinking. After running the process, Database B occuppies a large percentage of the buffers. I...

Adding the second instance would also include adding memory. That way both instances would have the same memory the current one has now.

Carl,

Thanks for the reply. I'll get a chance to test this on Sunday. Provided that the results support my thoery, will moving each DB to its own instance...

One Stat. that was pushing me toward this idea was the Buffer Cache Hit Ratio. It is generally very good (>99%). But after running a large process in...

I checked the SQL error log. The only entries during the 6 hours, that this process was running, are a handful of user login errors (bad PW type stuff).

My theory is not that I am running out of memory. It's that I am seeing the LRU behavior of cache. Stuff from database A gets kicked out...

Haven't looked (I will). Why would you expect anything in the log? Nothing is breaking, it's just slow for a while.

That what I thought and tried before posting this question:

Msg 4319, Level 16, State 3, Line 1

A previous restore operation was interrupted and did not complete processing on file 'LogTest_Log'....

Only a few people are allowed to create databases. Provided they follow the established naming conventions (common suffix) I should have no problem selecting the databases from sys.databases.

I want...

Thanks for the reply.

I was just starting to look at that approach. I think it may resolve my issue. This is a development server where new databases get...

I had the feeling there was something simple that I was overlooking. That solved my issue. The setup notes were a bit misleading. Thanks for the help.