Viewing 15 posts - 5,491 through 5,505 (of 7,499 total)
0) keep your head cool. Know what you do !
1) disable automatic backup jobs !
2) make a new incremental log backup !
3) if you have the place or another 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
October 31, 2007 at 1:49 pm
- a (serverlevel) login trigger may server you very well
- a simple change of password may also do the trick if your applications support extrenalised credentials/passwords.
- and if I'm...
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
October 31, 2007 at 1:38 pm
-ACID (A Atomicity, a TXN is performed in its entirety or not at all) (C Consistency, a correct TXN takes the db from one consistant state to another) (I Isolation,...
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
October 31, 2007 at 1:34 pm
Indeed :ermm: I should have doublechecked (it) myself :blush:
back to the pile of perfmon/profiler files ...
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
October 31, 2007 at 8:40 am
have a look at the KB @ http://support.microsoft.com/kb/916287
Maybe the fix list rings a bell.
If you cannot find another reason why it slowed down, maybe it's worth to investigate .....
fixlist:http://support.microsoft.com/kb/894905/
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
October 31, 2007 at 7:44 am
I don't know if it is the case, but some things to keep in mind with an in-place upgrade :
http://sqlblog.com/blogs/allen_white/archive/2007/10/08/pay-attention-to-cluster-setup.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
October 31, 2007 at 5:11 am
- Maybe I've overread ... but did you apply Cumulative HofFix for sp4(build 2187)-KB916287 ?
It might be that due to increase of load or data, engine issues arrise ....
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
October 31, 2007 at 3:21 am
- also keep in mind with an in-place upgrade, all your databases (including the system databases) are still at db_level 80 (sql2000) !
- If you want to use the new...
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
October 30, 2007 at 2:12 pm
it's the physical processors that count, not the number of cores.
So in your case 2 will be the number of processors to license if you want to enjoy your 4...
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
October 30, 2007 at 2:05 pm
post upgrade steps:
-rebuild all indexes !
-sp_updatestats;
-dbcc updateusage (0) with count_rows;
-dbcc freeproccache
And offcourse then make full backups !
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
October 30, 2007 at 2:04 pm
this may be hard to find out, depending on the traces you are running.
Maybe even a log-analyser kind of application can dig into your msdb-logfiles to find out, if possible,...
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
October 30, 2007 at 1:59 pm
Peter Gadsby (10/29/2007)
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
October 29, 2007 at 9:00 am
just my 2ct.
Don't remove the clustered index ! drop all nci and then truncate the table.
Load the data sorted according to the clustered index definition. This way , your data...
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
October 29, 2007 at 8:33 am
Did you start with a "select * " to see what's the cause of this error ?
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
October 29, 2007 at 4:21 am
just another thought ...
avoid FREETEXT !
Freetext <> like !
Maybe a like predicate serves you better.
Check BOL !
WHERE A.City_Name like '%New York%' and A.state = 'NY')
AND ( B.Business_Name...
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
October 29, 2007 at 2:59 am
Viewing 15 posts - 5,491 through 5,505 (of 7,499 total)