Viewing 15 posts - 4,606 through 4,620 (of 7,502 total)
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
- please post the sqlserver version info.
Select Serverproperty( 'ProductVersion' ) as ProductVersion
- did you check the fixlist for the available cumulative hotfixes (9) for this 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
September 4, 2008 at 3:33 am
There is a separate KB you need to read which explains the procedure to follow for system databases !!
Check "Restoring the master Database" in BOL
http://technet.microsoft.com/en-us/library/aa176749(sql.80).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
September 4, 2008 at 3:06 am
Rem,
I would leave the affinity default.
Gail,
Thanks for the bol ref.
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 12:14 am
Yes you can.
We try to avoid it (just in case...)
Books online has the cluster install procedure.
-Keep in mind to prepare your Windows groups to host the instances service accounts
- Keep...
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 3, 2008 at 1:58 pm
Viewing 15 posts - 4,606 through 4,620 (of 7,502 total)