Viewing 15 posts - 1,081 through 1,095 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 28, 2008 at 9:52 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 28, 2008 at 9:18 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 27, 2008 at 11:06 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 9:36 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 9:20 am
Nevermind, grew a brain and pulled up the query. Looking now..
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 9:01 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 8:59 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 8:51 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 8:46 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 23, 2008 at 7:35 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 22, 2008 at 1:33 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 22, 2008 at 7:37 am
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 22, 2008 at 7:17 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 7:36 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 21, 2008 at 5:16 pm
Viewing 15 posts - 1,081 through 1,095 (of 1,790 total)