Viewing 15 posts - 2,356 through 2,370 (of 7,502 total)
aslamnepanagar (2/8/2011)
I have also observed the 4 instances(multi instance server) , sqlserver.exe using around 1.7 GB memory.
They are never crossing 2 GB.
As mentioned above we are using a 32...
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 9, 2011 at 12:08 am
Every job can be done in a primitive way.
Just not as fast, smooth, reliable, agile, ...
Why I like sqlagent ?
- managebility
- security
- job history (no need to log...
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 8, 2011 at 2:03 pm
maybe this SSC art can get you started with dbmail http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/
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 8, 2011 at 12:17 am
jeff.mason (2/7/2011)
ALZDBA (2/7/2011)
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
Dear Lord, I HOPE...
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 7, 2011 at 12:48 pm
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :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
February 7, 2011 at 8:11 am
some more info regarding compatibility mode can be found at http://technet.microsoft.com/en-us/library/bb510680.aspx
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 7, 2011 at 6:16 am
yes and yes and it 'll be ok.
mirroring works with log replication, so everything you do on your principal db will also be performed on your mirror db as long...
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 7, 2011 at 6:06 am
just my 2 ct:
Can you check if auto update statistics have been kicked off at the time you experience your issues ?
You have quit a number of indexes and stats,...
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 7, 2011 at 2:50 am
did you check an SSIS solution ?
alternative could be "bcp" import.
I try to avoid the openquery solution
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 6, 2011 at 5:57 am
I fear you cannot do that with sqlserver.
- a primary key is a constraint that enforces uniqueness for the column(s) combination. it is materialized by an actual index. If your...
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 6, 2011 at 5:49 am
With sql2005 auto update statistics is supposed to be better than with previous versions.
That frequent rate of update statistics should no longer be needed, so your issue might be avoided...
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 6, 2011 at 5:38 am
ref: http://support.microsoft.com/kb/955396
I'm not a specialist on install debugging.
Can you check the errorlog file of your sqlserver instance ?
In your posted file I found:
2011-02-05 21:03:09 Slp: Sco: Attempting to check if...
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 6, 2011 at 2:23 am
I think your missing link is a LOGIN created from your certificate.
Keep in mind you should also register the certificate in master db to be able to create a login.
Use...
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 6, 2011 at 1:38 am
SQL2008R2 <> SQL2008 !!
When you attach a db or restore a db, sqlserver checks the systems information level (=system catalog level) and performs the needed updates.
That's the reason you cannot...
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 6, 2011 at 1:07 am
and the big advantage is you have control over the job e.g. at maintenance time disable it or disable the alert.
One word (sentence) of caution:
Keep in mind, when disabling the...
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 5, 2011 at 1:34 pm
Viewing 15 posts - 2,356 through 2,370 (of 7,502 total)