Viewing 15 posts - 4,606 through 4,620 (of 7,506 total)
marco.crescini (9/5/2008)
...ten mnutes ago i rechanged the transaction log model to simple(minimun)...
- How big is your transaction log file ?
- what's the growth size for the log file ?
- is...
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
September 5, 2008 at 7:45 am
Everything will still work, but will only use a single db-thread to accomplish the queries.
So it may need more time to complete, but your error will nolonger occur.
You may want...
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
September 5, 2008 at 6:06 am
Can you apply the workaround (i.e. disable parallelisme) ?
from KB319184
WORKAROUND
To work around this behavior you can either:
•Use the query hint (MAXDOP=1) to avoid a parallel query plan.
-or-
•Set the max degree...
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
September 5, 2008 at 4:11 am
Did you read and apply the hotfixes mentioned in KB918483 http://support.microsoft.com/kb/918483
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
September 5, 2008 at 3:32 am
are you using AWE ? http://support.microsoft.com/kb/899761
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
September 5, 2008 at 3:09 am
8.00.2039 is the regular SP4
Is this a multi processor or multi core box ?
if yes: IMO your should apply the cumulative hotfix I mentioned earlier.
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
September 5, 2008 at 2:23 am
Chandu (9/4/2008)
Then, multiple instances will occupy huge space.. right ?.. i mean 2 instances will occupy double space
Your extra software will need space, your extra databases will need space, 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
September 4, 2008 at 11:53 pm
You didn't post the @@version.
This is a sqlserver parallelism issue.
Did you also apply Cumulative HofFix for sp4(build 2187) - SQL2000-KB916287-v8.00.2187 ?
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
September 4, 2008 at 11:48 pm
Did you try DavidBs workaround ?
What were the results ?
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
September 4, 2008 at 11:45 pm
may sound stupid, but would attaching a USB-drive (low cost high volume (up to 1 TB)) help out to make your local backup ?
Short term, very low cost.
And then...
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
September 4, 2008 at 1:16 pm
If you are allowed to use xp_cmdshell you could perform
- your alter
- then put the db offline
- xp_cmdshell 'xcopy "c:\thefile.ldf" "x:\thenewwpath"'
- and alter db online.
With sql2005 you need...
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
September 4, 2008 at 1:11 pm
Please check this bugfix :
http://support.microsoft.com/kb/319184
This hotfix states "This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3"
Which is your sqlsever @@version ?
(maybe it's time to implement...
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
September 4, 2008 at 4:56 am
Chandu (9/4/2008)
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
September 4, 2008 at 4:18 am
double check your provided ddl data used during install!
I've found this to be interesting :
http://www.sql-server-performance.com/da_email_functionality.asp
Can your service account reach the mail 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
September 4, 2008 at 4:11 am
like from prod to dev ?
make the .bak file available to your sqlagent service account on your dev-server and have a job restore the db.
Alter database mydevdb set single_user with...
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
September 4, 2008 at 3:39 am
Viewing 15 posts - 4,606 through 4,620 (of 7,506 total)