Viewing 15 posts - 46 through 60 (of 2,462 total)
shahgols (11/7/2013)
but for some reason today it is very slow.
There must be any reason.. some immediate action done like
1 data migration (heavy DML on related tables) which...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 4:02 am
shindle 17293 (11/7/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 3:56 am
Maddave (11/7/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 3:36 am
Thanks but can you explain how the contention can be avoided by NUMA ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 7:40 am
dwilliscp (11/5/2013)
Currently our Cost of THreshold for Parallelism is 5
you also need to increase value of threshold to avoid early parallelism occurence
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 6:56 am
Carl B. (11/7/2013)
that may contains several thousand conversion scripts.
is it ? :pinch:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 6:52 am
Welsh Corgi (11/7/2013)
Cool script.Thanks everyone.
Did you find the issue ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 6:38 am
Did you miss colon (:) before your drive letter I it should be
'I:\MSSQL\log\MyDW.ldf'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 5:08 am
chandan_jha18 (11/7/2013)
sqlnaive (11/7/2013)
it can do it fast enough plus doing it this way controls your CPU else delete operation is just nasty.
its also perfect way to manage the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 4:59 am
steven.ensslen (11/6/2013)
They need a more complex solution that does less IO and doesn't put pressure on their transaction log.
IF you handle the records in bunches .. it will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2013 at 2:06 am
JimS-Indy (11/6/2013)
What does "blocked" mean? Do you mean some sort of deadly embrace? I'm not sure how to react....
i have experinced it in recent times. that same...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 6:27 am
alex.valen (11/6/2013)
The database will be used read-only when it's ready.- Alex
Rebuild all the indexes (preferably clustred ones) just before you are making the database read-only
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 6:08 am
i suspect with large amount of data ..your query might get blocked ..
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 6:03 am
you need 5 different results from 5 different filter(mentioned above) so your queries will work as expected.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 4:27 am
you need to compare exec plan in both the scenarios.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 4:25 am
Viewing 15 posts - 46 through 60 (of 2,462 total)