An interesting idea...

Having no more experience than reading books online, here is an interesting idea I would like to run by you guys and you can let me know if it is feasible or tell me I need to put the crack pipe down...

We are going to increase the number of disks in our SAN, and I was speaking with the SAN administrator and he mentioned the shuffling of logical drives to match the new space. He said he is going to have to go through quite a few combinations/permutations on figuring out the best configuration for what data goes on the old vs. new to get the optimal space.

Is this something that can be modeled out? I can write something that recursively figures it out, but why not explore fun ideas with tools that may be able to do it?

Thank you in advance,

John Hennesey

If you collect enough data you can easily build models to predict what best performance. You should include things like load, etc. You can likely start off by using the Analyze Key Influencers tool in the Data Mining Addins for Office 2007 to get a rough idea of what factors indicate the best configuration.

HTH

-Jamie

|||cool - thanks for the ideas!

an error while trying to read .sdf file from the pc application ? please help

hi

i have a problem with reading sql mobile database existed on the pc

i made a sql mobile database connection with ( Add New Datasource ) and then set

the datasource of dataviewgrid to display the returned dataset .

at run time i have an exception said :

cann't find the library with the name sqlceme.dll as i remember ,

can you help me solving this problem because i very need this step , please ?

regards

This looks to be a Sql Mobile setup or configuration issue. Moving the thread to the Sql Mobile forum.|||

SQL Mobile did not support Windows Applications before. It was integrated only with Device Applications. However, we will be releasing SQL Server Everywhere on desktop which you can use on desktop.

See the following URL for more details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295034&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||Is it posible to provide a link to the thread in the Sql Mobile forum?

an error while trying to read .sdf file from the pc application ? please help

hi

i have a problem with reading sql mobile database existed on the pc

i made a sql mobile database connection with ( Add New Datasource ) and then set

the datasource of dataviewgrid to display the returned dataset .

at run time i have an exception said :

cann't find the library with the name sqlceme.dll as i remember ,

can you help me solving this problem because i very need this step , please ?

regards

This looks to be a Sql Mobile setup or configuration issue. Moving the thread to the Sql Mobile forum.|||

SQL Mobile did not support Windows Applications before. It was integrated only with Device Applications. However, we will be releasing SQL Server Everywhere on desktop which you can use on desktop.

See the following URL for more details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295034&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||Is it posible to provide a link to the thread in the Sql Mobile forum?

am I reading this right?

When I see this in my Maintenance Plan job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
It could mean a FF of 10, but thats not the way Im reading it.
TIA,
ChrisR
Yes That is a fillfactor of 90%
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> When I see this in my Maintenance Plan job:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
> I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
> It could mean a FF of 10, but thats not the way Im reading it.
> --
> TIA,
> ChrisR

am I reading this right?

When I see this in my Maintenance Plan job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
It could mean a FF of 10, but thats not the way Im reading it.
TIA,
ChrisRYes That is a fillfactor of 90%
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> When I see this in my Maintenance Plan job:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
> I think that means a Fill Factor of 90%, leaving 10% free. Is that correct
?
> It could mean a FF of 10, but thats not the way Im reading it.
> --
> TIA,
> ChrisR

am I reading this right?

When I see this in my Maintenance Plan job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
It could mean a FF of 10, but thats not the way Im reading it.
--
TIA,
ChrisRYes That is a fillfactor of 90%
http://sqlservercode.blogspot.com/
"ChrisR" wrote:
> When I see this in my Maintenance Plan job:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
> I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
> It could mean a FF of 10, but thats not the way Im reading it.
> --
> TIA,
> ChrisR