Viewing 15 posts - 3,421 through 3,435 (of 7,499 total)
Indeed strange findings.
I think the best way to tackle this problem is to use sqlprofiler to capture the load launched on both engines (FULL).
Especially check the connections settings to actually...
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 1, 2009 at 8:19 am
My guess your alias references are resulting to these strange findings !
Did you try using aliasses for both objects
DECLARE @helperStr8000 AS VARCHAR(8000)
SET @helperStr8000='bcp "SELECT * FROM dbname..tablename x
WHERE EXISTS...
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 30, 2009 at 7:06 am
if you use "dirty reads" you allow your applications to use uncommitted data !
No complains are accepted for that ! :unsure:
Cursors can cause the need to be materialized in...
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 30, 2009 at 7:01 am
Start here :
- Gails very nice summary: http://www.sqlservercentral.com/articles/64582/
- Books online topic "Implementing Restore Scenarios for SQL Server Databases"
You really need :
- Full backup (= snapshot of your database)
- log backup...
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 30, 2009 at 6:50 am
Igor Marchenko (9/29/2009)
ALZDBA,Could you please elaborate on how you save and analyze cache? Do you save contents of master..syscacheobjects or corresponding DMV? What kind of analysis do you perform?
Thanks,
Igor
I would...
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 30, 2009 at 1:44 am
the urls both state on 32-bit win2003 std edtn : 4Gb is the max.
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 29, 2009 at 6:19 am
it depends:
- 32 bit 4GB max
- 64 bit 32GB max
http://technet.microsoft.com/en-us/library/cc758523%28WS.10%29.aspx
or
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 29, 2009 at 5:42 am
Start with properly design of your own tables !
DON'T use varchar(max) for everything ! Only use it if needed (>8000 bytes to be stored in a single column)
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 29, 2009 at 5:04 am
Is this a single shot operation ?
Use the import / export data wizard in enterprise manager/instance/database/tables rightclick on a table object.
Check out DTS in books online
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 29, 2009 at 5:02 am
Steve already couvered the DRP part.
Just to add a little bit to Keep in mind:
- SQL2005 has many features "off by default" on a fresh install. If you perform...
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 28, 2009 at 11:56 pm
Nic-1052152 (9/28/2009)
I have two front ends for my database; an old one in access and a newer one in vb.net.
I have a script which will script many new clients...
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 28, 2009 at 10:29 am
Be sure to double check your sql2000 settings (config + security) before starting the upgrade.
In case of DRP, you may have to start from sql2000 again, so if you don't...
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 28, 2009 at 10:21 am
Unless you capture plan cache, you have no means of history !
And if thing start going bad, it may go steep downhill !
Bad design (view on view, ..) probably ......
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 28, 2009 at 7:43 am
Works like a charm.
Thanks for the tip Starunit. :smooooth:
Keep in mind, that with every hotfix / servicepack, this needs to be rechecked (composition of the xml as well as 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
September 28, 2009 at 1:26 am
Nice feedback Jack.
Keep in mind 24h don't make a week, month , year 🙂
Did you trace on the same weekday as when you detected the growth ?
Well, it is a...
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 28, 2009 at 12:22 am
Viewing 15 posts - 3,421 through 3,435 (of 7,499 total)