Viewing 15 posts - 406 through 420 (of 1,790 total)
Derrick Smith (1/25/2011)
The SQL job step that starts the agent needed to have -Continuous in the command line.
Oddly enough, I never changed this and...
January 26, 2011 at 11:28 am
Did this get resolved? If so, it would be good to update with what you found. Thanks.
January 26, 2011 at 11:21 am
Great, I'll look forward to hear how things work out for you. One note that I didn't make clear in my last post, subscriptionstreams are available in 2005 so you...
January 20, 2011 at 3:52 pm
Yes, you can replicate SQL Server 2008 to 2005. For an extensive overview on the compatibility of versions check out THIS ARTICLE.
Read the section titled "Supported Versions of SQL Server".
January 20, 2011 at 3:17 pm
If Replication is the requirement then yes there are some tweaks that can be done with Server 2008 that will help replication, mainly in the area of network configuration. I...
January 20, 2011 at 3:11 pm
Replication and large batch loads don't play well together. While you can do some things to help replication out if you are constantly playing catch-up now it probably won't be...
January 20, 2011 at 12:41 pm
The only variation I can think of with that would be to make the ddl change on one of the publishers and allow it to be replicated. Then delete the...
January 20, 2011 at 11:57 am
Out of curiosity, what are you using as a workaround?
January 20, 2011 at 7:44 am
Hmmm, that is interesting. I can't think of why that would happen but I will try to test it tomorrow sometime and see if I can come up with anything....
January 19, 2011 at 3:21 pm
You should check out the procedure that Adam Machanic produced called sp_WhoIsActive. It will do what you are describing and has some great features to look at activity over time...
January 18, 2011 at 1:00 pm
Craig Farrell (1/14/2011)
It's a matter of isolating your primary bottlenecks and working to make sure they don't get overwhelmed.
We need a "Like" button on here. 🙂
January 14, 2011 at 3:25 pm
Sincerely I would be hard pressed to rank them. In my present environment we place a high emphasis on reads due to the volume of activity that we have on...
January 14, 2011 at 3:12 pm
dajonx (1/14/2011)
I was wondering what information is important for you in regards to tuning a query. Is my ranking in terms of importance accurate?
1) Elapsed Time - SQL Server...
January 14, 2011 at 2:47 pm
It looks like it is dying on the snapshot. Can you right click on the publication and select "View Snapshot Agent Status". If that looks ok, then it is having...
January 13, 2011 at 3:46 pm
This is a logged operation - from Books Online;
"The defragmentation is always fully logged, regardless of the database recovery model setting. For more information, see ALTER DATABASE (Transact-SQL). The...
January 13, 2011 at 3:43 pm
Viewing 15 posts - 406 through 420 (of 1,790 total)