Viewing 15 posts - 1,471 through 1,485 (of 2,436 total)
If the event logs have nothing and the SQL Server errorlog does not have a "sghutdown" line and the cluster.log file looks OK (be wary the cluster.log file is only...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 8, 2006 at 11:13 am
It does sound like a type of network issue. You should ping the server short name and the server long namr (FQDN). Based on the results your network folks can...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 8, 2006 at 10:15 am
Does the SQL Server errorlog show a normal shutdown request or not ?
Have you examined the "cluster.log" file ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 8, 2006 at 10:00 am
I could be wrong on the second half of the answer ... maybe someone else can confirm:
SQL Server is SMP aware - i.e uses multiple processors
SQL RSS is not SMOP...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 8, 2006 at 9:55 am
Let me begin with a quote - "Locks only keep honest people out".
Under normal circumstances I would use an AD group for the SQL Server Adminstrators. But in a "super-paranoid"...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 8, 2006 at 9:41 am
Fatastic script Lowell ...I had the need to write one and 'viola' ... yours was there ... thanks !!!
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 7, 2006 at 1:48 pm
There are Evaluation copies and the Developer Edition. Again, google is your friend !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 7, 2006 at 1:24 pm
Integrated Security is the way to go. Your 'seniors' are slightly off base (partially incorrect in their assumptions) about the way things work. Yes they are somewhat correct, if you...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 7, 2006 at 1:16 pm
"tame of monkeys" ???
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 7, 2006 at 10:02 am
I disagree your statement about not/never deleting the Builtin\Administrators. You can do it without ill affects if youy do your homework. Deleteing Builtin\Administrators (or at a minimum revoke login) does...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 6, 2006 at 9:34 am
By 'stand alone' I assume tat you mean 'workgrpoups'. If this is the case then you need to put things in a domain.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 3, 2006 at 12:46 pm
Where are the input files ? On the server or a mapped drive ? If they are on a mapped drive then network latency may be hindering you a bit....
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 3, 2006 at 12:44 pm
Industry is healthcare
SQL Server
21+ SQL Servers
480+ databases
50+ applications
Oracle
5 Servers
5 applications
UDB2
4 Servers
2 applications
Number of DBAs = 1
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 3, 2006 at 12:41 pm
Here's doing it the MS way:
1) Provide 24x7 performances monitoring of SQL Server.
2) Provide real time monitoring and alerts
5) Store historical performance data.
6) Provide performance trend reports
Items 1,2,5...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 3, 2006 at 12:02 pm
No 'raj' ... the .bat or .cmd only changes the address space the command file executes in. .bat is shared 16 bit space and .cmd is protected 32 bit space.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 3, 2006 at 11:17 am
Viewing 15 posts - 1,471 through 1,485 (of 2,436 total)