Viewing 15 posts - 2,431 through 2,445 (of 3,060 total)
balbirsinghsodhi (7/30/2009)
3. checked execution plan. All the tables are taking index seek.
:pinch: All tables? Are you sure? something about it doesn't sounds good.
Look at what changed in the environment since...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 30, 2009 at 2:05 pm
So... three days discussing this issue and counting, huh? 🙂
Wondering why my two simple questions never got an answer, they are:
a) Is there a purging or archiving strategy I could...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 30, 2009 at 7:06 am
How big is the affected database?
If all business wants is to have a snapshot, have you considered taking a full backup and restoring it as the new database?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 30, 2009 at 6:52 am
kchaluva (7/23/2009)
... we have tested our OLTP databases with 0.5 TB but we need to spec out a system for 40 TB.
I'm a little puzzled about reading "OLTP" and "40...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 30, 2009 at 6:48 am
dmw (7/29/2009)
This seems to have the following snags
(a) One-to-one...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 29, 2009 at 1:19 pm
Rad (7/29/2009)
yes, there are indexes in the table.For other clients with less data, the pages load quickly.
Chances are indexing strategy may require some re-work 😉
What do you see in offending...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 29, 2009 at 6:42 am
I see. Solution would be a check (domain) constraint pointing to a linked server, you can find documentation here http://msdn.microsoft.com/en-us/library/ms188258.aspx
Disclaimer.
I wouldn't do it. This solution would force SQL Server...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 28, 2009 at 1:54 pm
MTY (7/28/2009)
It takes around 120secodns cause the table is not partitioned yet (I guess)
So you have a daily ETL process that runs for 120 seconds?
Imagine you work for a week...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 28, 2009 at 1:46 pm
Tables are partitioned for just two possible reasons: 1) To help during purging and/or, 2) To help during quering.
If a partitioning strategy does not matches at least one of the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 28, 2009 at 1:37 pm
Validation of userid should be done at login time, not at the time application is inserting/updating every single row -such a solution would add a big deal of overhead, for...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 28, 2009 at 1:28 pm
:w00t: MySQL? this is the Oracle section of an SQL Server forum; probably not the best place to post your MySQL question. :blink:
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 28, 2009 at 9:43 am
Mazharuddin Ehsan (7/26/2009)2. database code (UDF, trigger, procesures etc) migration
As stated by poster he does not intends to migrate code -adding white noise may lead to confusion.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 26, 2009 at 9:06 am
Have you or the application run a defrag on tables and or indexes?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 24, 2009 at 12:41 pm
Choose one of the NDF file then post both Size and Available space for the last week, daily snapshots.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 24, 2009 at 11:20 am
Use SSIS as suggested by Jeff. Pay attention to datatypes.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 24, 2009 at 11:16 am
Viewing 15 posts - 2,431 through 2,445 (of 3,060 total)