Any help is appreciated.

Thanks for your reply..

Yes, I dont depend on Task Manager.

Hence I verified all the possible areas and now its time to fix the issues.

Could you please help me with any...

Buffer Pool Usage at the Moment

BPool_Committed_MB BPool_Commit_Tgt_MB BPool_Visible_MB

--------------------------------------- --------------------------------------- ---------------------------------------

32764.000000 32764.000000 32764.000000

Based on the above findings, I could determine its buffer pool issue.

But, I am confused of task Manager SQL...

Please find the actual execution plan.

Please let me know for any recommendations and modifications in the query as posted earlier.

The logic is, we need to pull complete data from a...

Mirroring should be newly configured between the servers again.

Thanks for your response.

As per the logic we need to fetch full data from tables.

I modified the script using temp tables in it is working as expected, normal run as...

Thanks for your reply.

I tuned it to better than earlier, since earlier query was bit critical with joins.

But I am not that much proficient to minimize the query and tune...

Hope this helps...!

http://msdn.microsoft.com/en-us/library/ms147921.aspx

use [$(PublisherDatabase)]

--Drop all subscriptions

exec sp_dropsubscription

@publication = N'TestPubs',

@article = N'all',

--@subscriber = [$(SubscriberServer)]

@subscriber = N'all',

@destination_db = N'all'

--Drop publication

if exists (Select 1 From...

Hope this helps you with some understanding..

http://msdn.microsoft.com/en-us/library/ms191295.aspx

http://www.sqlservercentral.com/blogs/pearlknows/2010/12/13/upgrading-to-sql-server-2008-a-comprehensive-checklist/

This could you help you to understand the setup and process.

http://msdn.microsoft.com/en-us/library/ms146922(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms151196.aspx

Some more information from external blog - http://sqlphilomath.wordpress.com/2011/08/07/how-to-configure-transactional-replication-with-updatable-subscriptions-step-by-step/

NOTE : http://msdn.microsoft.com/en-us/library/ms143550%28v=SQL.110%29.aspx

Check the services running from Config Manager. Check all are enabled.

I just did this last week. You can follow the instructions from - http://msdn.microsoft.com/en-us/library/cc707783.aspx

It should run and upgrade...

Hope this help...!

exec sp_dropserver @server = 'ASMREPLICADB' ,@droplogins = 'droplogins'

go

-- Add linked server

EXEC sp_addlinkedserver

@server = 'ASMREPLICADB'

, @srvproduct = ''

, @provider= 'SQLOLEDB'

, @datasrc=...

If SQL is consuming 2.3 GB, and if you see /3G switch already enabled, why you want to remove ?

If you have 4 GB of RAM, I would go setting...

Check SELECT @@version.

If it is SQL Server 2008, please follow below. If you have tried repairing option. Check again SELECT @@Version.

For SQL Server 2008:

Download the Service pack 3 manually and...

Thanks much for your reply, anymore suggestions or changes on the script, that I have been using ?

It wont result for SQL Server 2012 and R2 versions.

Any help on that...