Viewing 15 posts - 181 through 195 (of 243 total)
george sibbald (7/18/2009)
process basically the same.
apply the SP to the active mode, use cluster admin if you want to stop SQL, run the SP...
July 18, 2009 at 11:49 am
ps (7/18/2009)
sudhakara (7/18/2009)
Reason behind my question is , i am going to create one data file for each cpu processor with equal size for tempdb
what is the relation between...
July 18, 2009 at 8:12 am
GilaMonster (7/18/2009)
GAM pages are per file. Each file will have its own GAM pages tracking extent allocation within that file.Why are you asking?
thks for your reply ..
Yes ..i knew...Reason behind...
July 18, 2009 at 6:15 am
george sibbald (7/17/2009)
Procedure:
Stop all connections to the databases(s),...
July 17, 2009 at 4:45 pm
Steve Jones - Editor (7/15/2009)
A physical drive is...
July 15, 2009 at 2:45 pm
Steve Jones - Editor (7/15/2009)
There is no benefit. A logical drive is an administrative item in Windows.
thks for your reply ...is it work in the same as well in the...
July 15, 2009 at 2:20 pm
Animal Magic (7/11/2009)
in what context?? file placement/performance/difference between the two??
I want know what does it mean in RAID and explain in the all context ...
July 11, 2009 at 6:03 am
ALZDBA (7/6/2009)
We now only have SP3 instances with sql2005 and are...
July 6, 2009 at 10:55 am
ALZDBA (7/6/2009)
Why ?
- bugs have been cleaned up
- new features have been added (SSB, logon triggers,..)
- performance optimisations
- SSMS menu items have been shifted around (SP2)...
July 6, 2009 at 6:34 am
ALZDBA (7/6/2009)
Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS
, Serverproperty( 'Edition' ) as Edition
, Serverproperty( 'InstanceName' ) as InstanceName
,...
July 6, 2009 at 4:16 am
ALZDBA (7/5/2009)
Did you change the SAC connection from localhost to the logical server name of your sqlserver instance ?e.g. mysqlserver\myinstance you should connect to mysqlserver.
Yes ...After that only its allowing...
July 6, 2009 at 2:02 am
ALZDBA (7/5/2009)
did you try this in SSMS:EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
Yes .. i have enabled that by executiing that query already ..but issue is i could not able to...
July 5, 2009 at 3:24 am
MarkusB (5/29/2009)
sudhakara (5/29/2009)
July 4, 2009 at 2:27 pm
ALZDBA (7/4/2009)
With clustering stuff, many thing must be managed using cluster administrator!What are you looking for ? (With regards to instance management)
i want enable the DAC remote acces from SAC
July 4, 2009 at 6:13 am
i am also facing the similar problem in my sql server clustering configuration . it was not allowing me to open the surface area configuration wizard after changing the remote...
July 4, 2009 at 12:57 am
Viewing 15 posts - 181 through 195 (of 243 total)