Viewing 15 posts - 4,081 through 4,095 (of 7,502 total)
once a connection is established, communication performance may depend on the protocol it uses.
The sql performance for equal queries will be the same.
Also keep in min what kind of...
February 1, 2009 at 12:26 pm
Jeff Moden (2/1/2009)
February 1, 2009 at 11:00 am
Jeff Moden (1/31/2009)
February 1, 2009 at 6:30 am
I'm glad you resolved the issue.
As you've experienced, on a cluster, you need to use the correct tool (indeed: Cluster administrator) for a clustered service to be available !
Been...
January 30, 2009 at 12:25 am
keep in mind SAC should not be used on a clustered instance!
You should use cluster manager to configure (stop/start) parts of this sqlserver instance.
January 29, 2009 at 2:34 pm
madhu.arda (1/28/2009)
I did this by going to the active node and connecting virtualserver\instance and management studio, query editor
Is his on the node where you implemented the SP3 or on one...
January 29, 2009 at 12:23 am
Max (1/28/2009)
.... Does anyone still do that or is it all fibre optic SANs.
This is still a best practise.
SANs may help you on reliability, provide means of backup, ease of...
January 29, 2009 at 12:21 am
it is strange that F5 (refresh) on SQLagent or a disconnect/connect doesn't solve the issue.
Are you performing this on a client or at one of the nodes of the cluster...
January 28, 2009 at 1:45 am
It's a petty they've put a "Retired KB Content Disclaimer".
Apparently it isn't flashy anymore to summarise basic symple guidelines.
It must all be point and click and it will work..... until...
January 28, 2009 at 12:13 am
madhu.arda (1/27/2009)
-- show Agent XPs state (0/1)
EXEC sp_configure 'Agent XPs'
GO
Result:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'agent XPs' does not exist, or it may...
January 27, 2009 at 3:14 pm
This is a nice case:
Someone called the fire depatement to help on this situation:
They have a nice x64 4proc (each 4 cores) going totally somewhere I didn't want it to...
January 27, 2009 at 7:09 am
madhu.arda (1/26/2009)
But In my case, iam able to see the SQL Server Agent node .So this means, the monitoring tool is showing wrong thing?
How it effects if Agent XPs option...
January 27, 2009 at 12:10 am
I think you can, but you'll have to check your vm docs.
(We don't have vmware)
January 27, 2009 at 12:05 am
I didn't experience that overhere.
- do you rebuild indexes on a regular basis ?
- Are there any "missing indexes" reported ? (large numbers)
This is a very informative article:
MS best...
January 26, 2009 at 1:36 am
Viewing 15 posts - 4,081 through 4,095 (of 7,502 total)