Viewing 15 posts - 6,556 through 6,570 (of 9,244 total)
Ok, for a start you should really be using
ALTER INDEX ...........REBUILD
ALTER INDEX ...........REORGANISE
The drives for the tempdb are they local RAID. SATA or SAS, SAN based storage, .........?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2011 at 2:23 am
this thread is 3 years old!! Theres nothing like raising the dead is there 😀
Please start a new thread in future
You may add the file without restarting
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2011 at 5:00 pm
balasach82 (9/24/2011)
we have tempdb in separate drive and 5 filegroups, primary, and log drives.. Any idea what the error means and how to avoid the 15 seconds error.
can you give...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2011 at 3:55 pm
what size is the file you are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2011 at 4:43 am
i've answered this in your duplicate post
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2011 at 6:56 am
MarvinTheAndriod (9/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2011 at 6:55 am
what messages do the individual logs show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2011 at 6:52 am
no, it should however be installed first. In fact 2005 set up program would have flashed a warning that no clustered msdtc app was present
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2011 at 3:21 pm
you can, and in fact you should, install a clustered instance of MSDTC to handle any distributed transactions for the clustered SQL Server instance(s)
you'll need a unique network name, IP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2011 at 11:13 am
I believe the quote below is pretty descriptive of your problem
ankur_libra (9/21/2011)
"Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2011 at 11:06 am
If you dont already have a 3rd party backup product i would install the 2 week trial version of either LiteSpeed or SQLBackup and use this to compress the backups...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2011 at 2:26 am
rdavies 35008 (9/21/2011)
Do you think the principal freezes when it disconnects/reconnects from the mirror?
Hard to say as i have not seen the system. When the mirror reconnects the databases will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:19 pm
rdavies 35008 (9/21/2011)
If the mirror is down then I believe the principal will just build up the transactions until the mirror comes back.
That is correct.
rdavies 35008 (9/21/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 12:59 pm
the mirroring scenario you are using requires a 2 phase commit process. A transaction occurs on the principal and is then written to the mirror. The transaction does not commit...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 12:14 pm
ankur_libra (9/21/2011)
Hi Perry,So you mean to say, that in Boot.ini file:-
--------------------------------------------------------------------------------
[boot loader]
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE - ONLY HERE /PAE IS REQUIRED
if you have no DEP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 12:03 pm
Viewing 15 posts - 6,556 through 6,570 (of 9,244 total)