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...
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...
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 ?
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...
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"...
March 8, 2006 at 9:41 am
Fatastic script Lowell ...I had the need to write one and 'viola' ... yours was there ... thanks !!!
March 7, 2006 at 1:48 pm
There are Evaluation copies and the Developer Edition. Again, google is your friend !
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...
March 7, 2006 at 1:16 pm
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...
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.
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....
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
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...
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.
March 3, 2006 at 11:17 am
Viewing 15 posts - 1,471 through 1,485 (of 2,436 total)