Viewing 15 posts - 4,081 through 4,095 (of 7,496 total)
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
So, what do you do without standards ?
Some won't do business with you if you're not certified ISO...
Which one to pick is up to the company.
IMO things like SOx or...
January 26, 2009 at 12:18 am
how long are they up and running after SP3 ?
Keep in mind SP3 stops and starts sqlserver a number of times, so buffer cache will be cleared !
(our clustered instances...
January 26, 2009 at 12:06 am
- your sqlagent has not been started (cluster manager)
(do you use SQLAgent ?)
- you can enable these procs this way:
-- enable Agent XPs
EXEC sp_configure 'Agent XPs','1'
RECONFIGURE
GO
This way you can...
January 25, 2009 at 11:51 pm
cluttering is another branche 😉
Steve showed you some good refs for SQLServer clustering.
Another good ref is the SQL Server 2005 Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx?familyid=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en
It always pays of to have...
January 25, 2009 at 10:39 am
Mad-Dog (1/25/2009)
has anyone that have sp3 install and setup this alert in the SQL alert doesn't suffer from...
January 25, 2009 at 10:34 am
Viewing 15 posts - 4,081 through 4,095 (of 7,496 total)