Re: Partition recommendation in the Database Engine Tuning Advisor

Hi

Table Partitioning is really only intended to be used with large tables
(10's to 100's of millions of rows) and is a feature of Enterprise Edition.

You probably don't have enough data.

Why do you want to use partitioning?

--
Mike

This posting is provided "AS IS" with no warranties, and confers no rights.


"Alex Petrovsky" <god_enigma@xxxxxxx> wrote in message
news:u3Qr$UqxGHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I have some problems with Database Engine Tuning Advisor. I can't find any
partition recommendation.

1)
I created a table containing two columns (int and char(16)) and filled it
with simple data:
1, 'string'
...
2, 'string'
...
3, 'string'
...

2)
Next was saved a trace file with simple select statements for my table:

select * from Tab where col1 = 1
select * from Tab where col1 >= 1 and col1 <3
....

3)
The "Full partitioning" option was seted on the "Tuning Options" tab

What I did wrong?



.

Relevant Pages

  • Re: SQL Server Yukon: Feature Cuts?!
    ... at least I know now that partitioning is still in there. ... Hash partitioning could guarantee us somewhat that the mails ... We can't vouch that any feature will remain in the product. ... > our product picture catalog. ...
    (microsoft.public.sqlserver.server)
  • Re: Fedora Coverstory in Linux Format
    ... I guess it was all in my imagination when I tweaked the partitioning on my laptop when I installed FC6. ... The partitioning installation page gives you choices like: take over that hard disk, keep existing partitioning or "custom partitioning." ... Only if you select "custom partitioning" does the installer give you a chance to screw things up with disk druid if you don't know what you're doing. ... I'd say it's a feature. ...
    (Fedora)
  • Re: HP Webcast this morning on Next-Generation Intel Itanium 2 processors
    ... >My impression is that the concept of hard partitioning ... >long predates any DECpaq implementation: it has been a feature of IBM ... I'm glad to hear that hp will support OpenVMS in that space in the ...
    (comp.os.vms)
  • Re: HP Webcast this morning on Next-Generation Intel Itanium 2 processors
    ... > My impression is that the concept of hard partitioning ... > long predates any DECpaq implementation: it has been a feature of IBM ...
    (comp.os.vms)
  • Re: Partition recommendation in the Database Engine Tuning Advisor
    ... I tried getting recommendation on ... Developer Edition and Enterprise Edition but without effect. ... Table Partitioning is really only intended to be used with large tables ...
    (microsoft.public.sqlserver.tools)
Quantcast