Viewing 15 posts - 4,081 through 4,095 (of 7,503 total)
- did you grant the operatorid usage for the mail profile ?
- if you RDC (remote desktop connection) the server, are you able to send a testmail ? (so server...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 2, 2009 at 9:59 am
did you check the various fn_split solutions posted at SSC ?
e.g.
http://www.sqlservercentral.com/articles/T-SQL/63003/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 2, 2009 at 9:56 am
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 1, 2009 at 12:26 pm
Jeff Moden (2/1/2009)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 1, 2009 at 11:00 am
Jeff Moden (1/31/2009)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 29, 2009 at 2:34 pm
:w00t::hehe::D
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 29, 2009 at 8:08 am
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 27, 2009 at 12:10 am
Viewing 15 posts - 4,081 through 4,095 (of 7,503 total)