Viewing 15 posts - 8,101 through 8,115 (of 9,244 total)
best way
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2010 at 5:51 am
xinyu.wang1 (4/10/2010)
active/passive, active/active are obsolete terms. Now the term is multi-instance.
It's not obsolete as active\passive refers to the Windows cluster itself and not SQL Server!
Example: A 2 node Windows cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2010 at 5:48 am
Niyala (4/7/2010)
Suppose I have two instances running on the Active node. Two instances on the passive node.
if the passive node has 2 instances then it is not passive is it??????
Take...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2010 at 12:26 pm
BOL always has some inconsistencies. In the copy i have it says you can move it but not recommended as if you do it is always returned to the Binn...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2010 at 12:04 pm
NJ-DBA (4/5/2010)
correction- i think it was “Read servicePrincipalName” and “Write servicePrincipalName”
Correct they are the permissions to assign in ADSIEDIT to the service account. You also need to trust the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2010 at 10:43 am
george sibbald (4/7/2010)
does SQL rely on info in the master database or the registry? I expect and hope the registry but have never actually tried out this scenario.
as far as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2010 at 10:38 am
george sibbald (4/7/2010)
Question I don't know the answer to............In SQL2008 if you restore a master database from a different server and the server the backup originated from had a different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2010 at 5:36 am
Satish-219904 (4/6/2010)
I will add make the max. memory change and add the sql service account to "lock pages in memory" option. Hopefully these two changes will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2010 at 10:28 am
drawlings (4/5/2010)
Lock pages in memory is advised only in cases where it proves to improve performance, experiment! In theory the setting should not be required....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2010 at 7:04 am
yes its only user dbs and model, msdb to worry about
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2010 at 7:02 am
Hi
the values all have different meanings. The buffer cache hit ratio should be compared against buffer cache hit ratio base. Take buffer cache hit ratio and divide by the base...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2010 at 3:45 pm
Satish-219904 (4/5/2010)
I have not applied "Lock pages in memory" option yet but planning to do this along with this change. Hopefully it should increase the performance of my SQL Server.
ensure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2010 at 2:21 pm
Satish-219904 (4/5/2010)
How can i moitor PLE (page life expectancy)?
which monitoring tool do you use. Perfmon has a counter available for this or view it via the following query
select cntr_value...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2010 at 2:11 pm
Saravanan T (4/5/2010)
Im rebuilding and reorganizing only the indexes which it required.
something i have seen before, ensure you dont have a maint plan with a rebuild and a reorganise...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2010 at 2:07 pm
george sibbald (4/2/2010)
sys.master_files possibly points to a bunch of file locations that don't exist so user databases will have to be dropped and reattached.
you can also perform a restore with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2010 at 2:02 pm
Viewing 15 posts - 8,101 through 8,115 (of 9,244 total)