I'm with most here, it isn't bad but it isn't what it could be when you compare it to SQL Prompt. I will say that it is not as sluggish...

Andy Lennon (10/28/2008)

Agreed. I think Phil's point about longer legacy support is a good one as well. I don't have any experience with Oracle systems, but i would think they're...

Other than the logins, what is the reason for restoring master? If it is just logins, you can script them out in an automated fashion at whatever interval you want...

It is not that surprising to me that it works, see that a lot as well but typically by changing the query a bit I can get the same plan...

Ok, stats are updated, so that shouldn't be the issue. Is the view that this is referencing indexed? Seems like everything is going directly against the base tables so, wondering...

Nevermind, grew a brain and pulled up the query. Looking now..

Them are some pretty big query plans mister... 🙂 Any possibility that you might be able to tell me which table the where criteria is filtering from so that I...

Have to agree with Kendal on option 1 as this will also keep the amount of data replicated down to that which is truly pertinent for the subscriber. Saves on...

It seems like the questions were answered so, a bit confused. However, setting the max server memory to be 14 GB should be good and allow plenty for the OS...

Step by step is difficult. However, there are many ways in which you can grow in knowledge. These forums being one of them, reading and replying to posts can be...

You didn't mention the drive configuration on the first server other than SAN. How many disks in the volume, what is the RAID configuration for that drive? On the new...

Adam,

xp_delete_file will not work for any files other than SQL Server backup files and SQL Server backup log files. It actually reads the header records of the files to verify...

At this point you have to start digging into the permissions on that folder and ensuring that the account running the process (as well as yourself) have access to it....

Log shipping won't work in your situation as the log restore process would of necessity block people out. I'm not sure if database mirroring would work but you could research...

Agreed that it would be good to analyze the hardware. I would also like to see the IO latency associated with the two servers. Try running this query on both...