Viewing 15 posts - 1 through 15 (of 16 total)
You can configure the mirror for databases on Server A
But you cannot do the mirror for databases on Server B.
September 25, 2014 at 12:50 am
Eirikur Eiriksson (9/24/2014)Quick question, is the database in SIMPLE recovery mode?😎
Eirikur Eiriksson (9/24/2014)
there is no any relation to database recovery mode
September 25, 2014 at 12:45 am
you can use profiler on third server to Monitor the sql statements which cause the CPU high.
get the sql statements from the DMV.
September 25, 2014 at 12:43 am
No. SSMS is not same as configuration manager.
if it is sql server 2008 or 2008 r2, you can type sqlservermanager10.msc
if 2012,please type sqlservermanager11.msc
Btw,there is no any operation system whose number...
September 20, 2014 at 2:55 am
you can firstly create the DBLink using GUI, and then generate the script.
then you can some interesting parameters.
BTW, why you use DBLink when configuring updated transnational replication
August 29, 2014 at 12:26 am
Actually, I do not know what you want to do.
migration or upgradation ?
August 26, 2014 at 2:44 am
If you have another server for migration and the server has the same or better hardware, you can do the side by side migration. and then you can control the...
August 25, 2014 at 11:33 pm
No, this is no any way to match your requirement.
August 25, 2014 at 11:08 pm
firstly, you should check how long will your sp runs.
then find whether can optimize it.
For example, it ran for 10 minutes one time. if you can optimize it(reduce the running...
August 25, 2014 at 8:30 pm
er.mayankshukla (8/23/2014)Yes, but dmv's like dm_tran_active_transactions Or dm_tran_database_transactionsdo not provided me the log length which I require to see which transaction is making my log size to increase.
do not provided me the log length which I require to see which transaction is making my log size to increase.
I have found...
August 25, 2014 at 7:05 pm
actually, we use receive top 1 in the interface sp.
i think what you need to do is:
1. increase the max_queue_readers parameter in the queue definition. the default is 1. you...
August 25, 2014 at 7:02 pm
Wison (8/22/2014)Hi all,I found the tempdb log file size of one instance increased to 200 GB.how can i get the root cause of the issue?any answer is appreciated.thanks.
I found the tempdb log file size of one instance increased to 200 GB.
how can i get the root cause of the issue?
any answer is appreciated.
August 23, 2014 at 2:42 am
EXEC master.dbo.sp_serveroption @server=N'YourServerName', @optname=N'data access', @optvalue=N'true'
you can use this script to add the data access permission in the linked server
August 23, 2014 at 12:19 am
Hi, in your post, you can find the data in the [Log Record] of fn_DBLog feedback.
but the string is too long.
create table c (name char(5))
insert into c select 'wison'
July 16, 2013 at 8:30 pm
It is SQLServer 2008 R2 RTM, Enterprise Edition(X64) on both sides of the mirror
June 13, 2012 at 7:35 pm