Viewing 15 posts - 4,936 through 4,950 (of 9,241 total)
opc.three (9/25/2012)
(
DB SYSNAME,
LogSize FLOAT,
SpaceUsed FLOAT,
Stat BIT
);
INSERT INTO #LOGSPACE
(
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 8:14 pm
Normally i would expect an error 5 if the backup couldn't be accessed during the restore part of the wizard. Haven't managed to recreate an error 2 yet.
What account...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 6:19 pm
opc.three (9/25/2012)
The SpaceUsedMB could be low if you ever switch the DB into the Bulk Logged Recovery Model and perform any minimally logged operations.
Yes, but bear in mind that log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 6:14 pm
to TempDB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 12:19 pm
Perry Whittle (9/22/2012)
When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 12:18 pm
laurie-789651 (9/25/2012)
Perry Whittle (9/25/2012)
SQLSACT (9/25/2012)
I have a quick question regarding pages moving from disk into memory
If I select * from a table, are all pages that make up the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:22 am
scogeb (9/25/2012)
I am going to try to restart the endpoint per Perry's suggestion next time this happens. I will post back the results at that time.
This should be your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:17 am
SQLSACT (9/25/2012)
I have a quick question regarding pages moving from disk into memory
If I select * from a table, are all pages that make up the table and indexes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:15 am
opc.three (9/25/2012)
I realize that. That is my motivation for adding in the coulmn that implies it is the amount of memory allocated as a locked page, i.e. AWE memory.
The point...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:11 am
opc.three (9/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 7:50 am
Kishore-132325 (9/25/2012)
ok, gotcha..but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?
What new principal?
The mirror session is created against the clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 4:37 am
Kishore-132325 (9/25/2012)
Yes multi instance cluster...DB Mirroring is in Asynch mode and Manual failover...
If the cluster fails over and the failover time exceeds the mirror timeout (default is 10 seconds) the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 3:56 am
Kishore-132325 (9/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 3:40 am
No, it's not. This value
locked_page_allocations_kb
is a part of
physical_memory_in_use_kb
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 1:33 am
saidapurs (9/24/2012)
I configured SQL cluster configuration successfully as Active /Passive but i am not understand how do i configure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 1:07 am
Viewing 15 posts - 4,936 through 4,950 (of 9,241 total)