Hyper Threading for a cluster envirnoment

Hi
We are running SQL server in a cluster environment and Hyper threading are
enabled in that servers. The application and Database servers are
different. The appliactions stores 2 MB size of acrobat files to the table
which contains more than 600000 records . We are finding some kind of
issues with this servers.
Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
that server .Is hyper threading cause any issue related to SQL Server
envirnoment.
Please reply
Regards
Swami
ganesh2012@.hotmail.com
Hi
I see no reason why you should. HT processors act like there are 2
processors installed.
What issues are you having?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||In general, hyperthreading is a good thing. There are some strange
behaviors on 8 or more processor clusters but these only happen under some
very specific conditions. I do find that you will need to lower the
maximium degree of parallelism to the actual physical processor count to
avoid oversaturating a system. Please reply with more details on exactly
what your symptoms are so someone here can give you a better answer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||Geoff N. Hiten wrote:

> In general, hyperthreading is a good thing.

> There are some strange
> behaviors on 8 or more processor clusters but these only happen under some
> very specific conditions.
Could jou post a link to some info on this?
Hans
|||Here is one I actually oberved. It is a very unusual set of circumstances
that caused the problem.
FIX: Intermittent query slowdowns and corresponding high CPU utilization
http://support.microsoft.com/default.aspx/kb/835864
Here was another fix earlier to handle some other synchronization
performance issues.
FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000
Service Pack 2
http://support.microsoft.com/default...b;en-us;818763
I am pretty sure SP2 had something in it for Hyperthreading, most likely
counting the processors correctly for licensing restrictions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hans de Bruin" <hans@.invalid.invalid> wrote in message
news:1107960610.727258@.draco.amc.uva.nl...[vbcol=seagreen]
> Geoff N. Hiten wrote:
>
some
> Could jou post a link to some info on this?
> --
> Hans

Hw can the cube be modified after deployment?

Hi,

We used cube in our project.

And the project is released to production environment.

Now we need to modify the cube.

Can anyone have any idea what are the ways we can handle this?

Appreciate any suggestion.

Sachin!

If this is an SSAS2005 cube you will have a project in BI-Developer Studio? Open the project and make the changes and redeploy the script to the SSAS2005 server.

The other way is to reingeneer a deployed cube. BI-Dev Studio have a project for this as well: "Import Analysis Services 9 database". Once you have a new project you can start making changes.

HTH

Thomas Ivarsson

|||The third alternative is to connect online to the cube. In Visual Studio go to File -> Open -> Analysis Services Database, and you will end up making changes directly to the cube on the server without having to deploy the changes - just hitting Save will make the changes immediatelly.|||

But without a blueprint/copy of what you have done. You should always work with a project?

/Thomas Ivarsson

|||In online mode you still have a project - it's just online project - everything is on the server. It is ultimately up to the developer in which mode he wants to work. (BTW, in AS2000 the only available mode was online mode).|||

We have deployed product at many client locations.

Now we need to add few things to the cube

But it is not feasible to go and change manually at all locations and same time client may not want that.

We are looking after creating an update for the product.

Now the question is how to update cube? One option is delete existing cube and create again with new xmla script and process cube.

Can you please suggest any other way to do so?