Partition recommendation in the Database Engine Tuning Advisor

23 Aug 2006 11:13 AM

Alex Petrovsky

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?

23 Aug 2006 11:47 AM

Michael Epprecht [MSFT]

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.

Show quote

"Alex Petrovsky" <god_eni***@mail.ru> wrote in message
news:u3Qr$UqxGHA.3408@TK2MSFTNGP03.phx.gbl...
> 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?
>

24 Aug 2006 11:52 AM

Alex Petrovsky

Thanks for fast reply!!!

I have 15 millions of rows in my table. I tried getting recommendation on
Developer Edition and Enterprise Edition but without effect.

Show quote

"Michael Epprecht [MSFT]" <michael.eppre***@online.microsoft.com> wrote in
message news:ejNuTnqxGHA.2384@TK2MSFTNGP05.phx.gbl...
> 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_eni***@mail.ru> wrote in message
> news:u3Qr$UqxGHA.3408@TK2MSFTNGP03.phx.gbl...
>> 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?
>>
>
>

25 Aug 2006 9:30 AM

Alex Petrovsky

Sorry, I didn't see your question. I still research this technology, and
want to know can I use the Tuning Advisor for getting right recommendation
for partitioning.

Show quote

"Michael Epprecht [MSFT]" <michael.eppre***@online.microsoft.com> wrote in
message news:ejNuTnqxGHA.2384@TK2MSFTNGP05.phx.gbl...
> 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_eni***@mail.ru> wrote in message
> news:u3Qr$UqxGHA.3408@TK2MSFTNGP03.phx.gbl...
>> 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?
>>
>
>