Viewing 15 posts - 31 through 45 (of 65 total)
If you just want to eliminate your fears ... then at this point i would suggest going through the monitoring scripts given in this white paper
go with a structured approach...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 4:39 pm
Please provide your topology/architecture ... how many publishers, distributors and subscribers ...... what is the sequence you are planning to restart them ???
generally replication does come back up pretty fine...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 4:21 pm
i second that ... caching
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 4:18 pm
it would not start until the previous run is finished .... you could test this out on a test box to have a working select statement and then a waitfordelay...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 3:34 pm
this does not help ... please read http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 2:46 pm
well .... as per licensing goes ... this could lead to a Windows Data Center Edition kind of a solution. You pay a huge sum, but the OS comes bundled...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 2:23 pm
trebor69 (8/26/2009)
We are experiencing a gradual slow down in performance, as SQL memory usage increases, which can only be solved by a re-boot.
if right now you are only using...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 1:12 pm
are you getting any SQL Server memory paged out ? you could check in the error logs for a message like "A significant part of sql server process memory has...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 12:31 pm
http://technet.microsoft.com/en-us/library/ms151870(SQL.90).aspx
this should help
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 10:58 am
Then rebuild all indexes to undo the fragmentation that the shrink caused.
Good point ... missed that one :satisfied:
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 9:12 am
looks like there is definitely some free space in your data file(s) ..... when you try to restore it through GUI .... do you get to see the files that...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 8:50 am
there is generally no limit to the snapshot replication per say .... but you could be limited by the cache size if the bcp file becomes large ......I have not...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 8:35 am
as you say that the code was the same on old server ... so i assume that also had a link server setup on the same server....
at this point...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 8:21 am
dmiller (8/25/2009)
for the database converted from Access to SQL/2005 it returns "The login already has an account under a different user name." And same error launching the application.
sounds like...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 3:45 pm
JonJon (8/25/2009)
I have about 3.75GB of memory.
I dont think PAE and AWE need to be enabled ... or What am i thinking :doze:
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 3:32 pm
Viewing 15 posts - 31 through 45 (of 65 total)