How can i configure SQL Server for clustring servers?

Hi
We are developing bussiness software for tourism company. Our application is
using SQL DB on MSSQL Server. We have a new customer and they have 500 or
more users.Around 300 users will be work on local network and 200 users will
be connect from remote side. My problem is how can i configure the sql
server's for best performance. We have just one DB for apllication. Am i
configure the sql servers for clustring.? I am wating for your ansvers. Thank
you"Batur KILIÇ" <Batur KILI@.discussions.microsoft.com> wrote in message
news:CB47B648-A5DE-4F9D-A94F-00E5F4DE8972@.microsoft.com...
> Hi
> We are developing bussiness software for tourism company. Our application
is
> using SQL DB on MSSQL Server. We have a new customer and they have 500 or
> more users.Around 300 users will be work on local network and 200 users
will
> be connect from remote side. My problem is how can i configure the sql
> server's for best performance. We have just one DB for apllication. Am i
> configure the sql servers for clustring.? I am wating for your ansvers.
Thank
> you
Clustering is a fail-over mechanism, not a scalability mechanism.
May be simpler to tune your application and buy a bigger server.|||Batur KILIÇ wrote:
> Hi
> We are developing bussiness software for tourism company. Our application is
> using SQL DB on MSSQL Server. We have a new customer and they have 500 or
> more users.Around 300 users will be work on local network and 200 users will
> be connect from remote side. My problem is how can i configure the sql
> server's for best performance. We have just one DB for apllication. Am i
> configure the sql servers for clustring.? I am wating for your ansvers. Thank
> you
Hi
Knowing that the customer has 500+ users doesn't tell a lot about the
load on the system...;-).
The first thing is to make sure that you design your application
properly and make the correct indexes etc.
I assume that you have some sort of idea on how the application performs
so based on that you should have an idea on how big a server you should
buy. Depending on the size, usage, design, complexity etc. of the
application, a dual proc server can be either way to small or really
overkill. Basically you should have enough memory and processor power
and a decent disk configuration. Then you can go on from that.
A decent disk configuration in my opinion will be to have enough disks
to create seperate arrays for OS files, Databasefile(s), logfile(s) and
backup. I'd then avoid RAID 5 for the logfiles and maybe for the
databasefiles (depending how much money you can spend) and then put
these on RAID 1 (or 10/01). Then buy 15 K disks rather than 10K and keep
in mind that the more spindles you have to read from the better (read)
performance you get.
With the above in mind, you'll be starting on a decent level. Then you
can start looking into specific areas if the performance isn't sufficient.
Regards
Steen Schlüter Persson
DBA

How can i configure SQL Server for clustring servers?

Hi
We are developing bussiness software for tourism company. Our application is
using SQL DB on MSSQL Server. We have a new customer and they have 500 or
more users.Around 300 users will be work on local network and 200 users will
be connect from remote side. My problem is how can i configure the sql
server's for best performance. We have just one DB for apllication. Am i
configure the sql servers for clustring.? I am wating for your ansvers. Than
k
you"Batur KILI" <Batur KILI@.discussions.microsoft.com> wrote in message
news:CB47B648-A5DE-4F9D-A94F-00E5F4DE8972@.microsoft.com...
> Hi
> We are developing bussiness software for tourism company. Our application
is
> using SQL DB on MSSQL Server. We have a new customer and they have 500 or
> more users.Around 300 users will be work on local network and 200 users
will
> be connect from remote side. My problem is how can i configure the sql
> server's for best performance. We have just one DB for apllication. Am i
> configure the sql servers for clustring.? I am wating for your ansvers.
Thank
> you
Clustering is a fail-over mechanism, not a scalability mechanism.
May be simpler to tune your application and buy a bigger server.|||Batur KILI wrote:
> Hi
> We are developing bussiness software for tourism company. Our application
is
> using SQL DB on MSSQL Server. We have a new customer and they have 500 or
> more users.Around 300 users will be work on local network and 200 users wi
ll
> be connect from remote side. My problem is how can i configure the sql
> server's for best performance. We have just one DB for apllication. Am i
> configure the sql servers for clustring.? I am wating for your ansvers. Th
ank
> you
Hi
Knowing that the customer has 500+ users doesn't tell a lot about the
load on the system...;-).
The first thing is to make sure that you design your application
properly and make the correct indexes etc.
I assume that you have some sort of idea on how the application performs
so based on that you should have an idea on how big a server you should
buy. Depending on the size, usage, design, complexity etc. of the
application, a dual proc server can be either way to small or really
overkill. Basically you should have enough memory and processor power
and a decent disk configuration. Then you can go on from that.
A decent disk configuration in my opinion will be to have enough disks
to create seperate arrays for OS files, Databasefile(s), logfile(s) and
backup. I'd then avoid RAID 5 for the logfiles and maybe for the
databasefiles (depending how much money you can spend) and then put
these on RAID 1 (or 10/01). Then buy 15 K disks rather than 10K and keep
in mind that the more spindles you have to read from the better (read)
performance you get.
With the above in mind, you'll be starting on a decent level. Then you
can start looking into specific areas if the performance isn't sufficient.
Regards
Steen Schlter Persson
DBA

How can i assign customize data to sql report

hi folks,
i want to assign customize data to sql report. i have one record related to a customer. i have its current balance. i have to show in report that after specific months how much its amount will be.
i have to show each years amount that user will get. i am showing report in my aspx page. how can i assign this customize dataset to report

Good Morning or Good Evening!
I could be mising something based upon your post - but -
When you develop a report in REporting Services - you have to define a DataSet
The dataset can "grab" data from Sql and you can define a text string (Select whatever, count(1) from whatevertableyouwant)
The dataset could also execute a stored procedure and if you have this information available within your database a T-SQL stored proc ) can be executed via the dataset definition of reporting services - then -
you should have no problems in defining the report display elements
still not sure - but I think not so hard!
best regards.

How can I add picture in microsoft sql server express 2005?

I would like to store small image in MSSQL server wich I can view by vb .net. For expample: I like to see each customer picture ID as I click on customer name from the customer table.

ThanksQuestion moved to SQL Server Forum.sql

How best to deploy database?

What would be the best way to deploy a database to customers?

Execute sql scripts to create the database on the customer's server, or distribute an .mdf file?

Package as msi?

Other ideas?

Hi,

if you vuild a database from sctach with only little data shipped with the database, I would go for the scripting. If you have more data you should do something like MSIing. If you don′t want to use an installer just ship the MDF file and leave it to the customer to attach the database.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

There is very little data in each newly deployed database. The customer uses an application front end to populate the database to their own specific requirements.

The applicationfront-end will be deployed via MSI as each customer will have multiple installations of it, each pointing at one or more database servers.

Having had little to do with MSI packages thus far is it easy to get an MSI to execute the scripts and/or attach a template MDF?

The way I see it, the database installer will execute under admin account on the server (same as account used to install SQL Server) so can connect using Windows Authentication. At that point I need to execute the setup scripts and/or attach the MDF. Further I need to execute scripts to generate a unique logon used as an application role per SQL Server instance so that the front-end application(s) can connect remotely.

Does this sound a reasonable way to go about it?

Many thanks for your input.

|||

That sounds good, I would offer the user a possibility to choose the instance where he wants to attach the database to (if more than one instance is present). Furtherone I would let him to choose to either connect to the server via SQL Server authentication or Windows authentication (because not all servers might have the local adminstrator group as sysadmins).

With that you should have a minimum of support calls :-) (If any problems occur, don′t forget to implement a logging mechanism which get the output of the executed script for debugging purposes)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

how are these queries evaluted differently by sql server?

I'm looking for the minimum date of an entry into a history table. The table contains multiple entries for the customer and the item with an activation and deactivation date for each entry.

I could use the following:

select customerId, item, min(activationDate) from history group by customerId, item

or a sub query

select customerId, item, activationDate

from history h1

where activationDate=(select min(activationDate) from history h2 where h2.customerId=h1.customerId and h2.item=h1.item)

How are these two queries parsed differently by SQL.

They return a different number of results.

Thanks,

karen

I'm guessing that customerId and item do not uniquely define a record in the table, is this true? If so, that would explain the difference in the amount of rows between the two result sets.

-The first query finds the minimum activationDate for each unique customerId and item.

-The second query finds the minimum activationDate for each customerId and item.

-If you add a group by customerId, item to the second query you should have matching result sets.

The inner query of the correlated subquery is processed once per record of the outer query.

|||

If you have the following data in the table:

CustomerID - Item - ActivationDate

1 1 1/1/2007

1 1 1/1/2007

The first query will return one record while the second query will return two. This is because (as the above post indicates), that the first query is returning a true grouping while the second will return duplicate records if there is duplicate data in the table.

|||

Bcs there are duplicate entries available on your database..

You can force DISTINCT class to fix this..

Sample..

Create Table #samplehistory (

[customerId] int ,

[item] int ,

[activationDate] datetime

);

Insert Into #samplehistory Values('1','1','1/1/2007');

Insert Into #samplehistory Values('1','1','1/2/2006');

Insert Into #samplehistory Values('1','1','1/3/2006');

Insert Into #samplehistory Values('1','2','1/11/2007');

Insert Into #samplehistory Values('1','2','1/11/2003');

Insert Into #samplehistory Values('1','2','1/11/2002');

select

customerId,

item,

min(activationDate) activationDate

from

#samplehistory

group by

customerId, item

select

customerId,

item,

activationDate

from

#samplehistory h1

where

activationDate=

(

select

min(activationDate)

from #samplehistory h2

where

h2.customerId=h1.customerId

and h2.item=h1.item)

/*

customerIditemactivationDate

-- -- --

112006-01-02 00:00:00.000

122002-01-11 00:00:00.000

*/

After duplicating one of the value.. You are result is correct but there are dupicate data in the result

Insert Into #samplehistory Values('1','2','1/11/2002');

select

customerId,

item,

min(activationDate)

from

#samplehistory

group by

customerId, item

/*

customerIditemactivationDate

-- -- --

112006-01-02 00:00:00.000

122002-01-11 00:00:00.000

*/

select

customerId,

item,

activationDate

from

#samplehistory h1

where

activationDate=

(

select

min(activationDate)

from #samplehistory h2

where

h2.customerId=h1.customerId

and h2.item=h1.item)

/*

customerIditemactivationDate

-- -- --

112006-01-02 00:00:00.000

122002-01-11 00:00:00.000

122002-01-11 00:00:00.000

*/

The group by class force the First query to avoid the duplicates (already distincted values are return).

After Distinct on second query,

Code Snippet

select distinct

customerId,

item,

activationDate

from

#samplehistory h1

where

activationDate=

(

select

min(activationDate)

from #samplehistory h2

where

h2.customerId=h1.customerId

and h2.item=h1.item)

/*

customerIditemactivationDate

-- -- --

112006-01-02 00:00:00.000

122002-01-11 00:00:00.000

*/

|||

Thank you very much for your help. I really appreciate the time.

Would you recommend a book for dealing with these kinds of sublties in SQL?

Karen

|||

Inside SQL Server 2005 T-SQL Querying by Itzik Ben-Gan is very good.

|||Ken Henderson's "The Guru's Guide to Transact-SQL" is also very good.

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.
You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.
|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
--
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.

Hotfix needed

Does anyone know how I can get the hotfix for 830466?
The kb article (http://support.microsoft.com/?kbid=830466)
says to contact microsoft customer service. When I ask for
free online support it asks for the product id. When I try
to check where the pid is, it's not listed. Our licenseing
folks have no idea what our pid is for sql server.You can find the product ID in the registry key
HKLM\Software\Microsoft\Microsoft SQL Server\80\Registration\ProductID
Jacco Schalkwijk
SQL Server MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.|||You can get a newer fix (878), which includes the fixes for 852, here:
http://support.microsoft.com/?kbid=838166
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:387301c46a86$d7ba28c0$3a01280a@.phx.gbl...
> Does anyone know how I can get the hotfix for 830466?
> The kb article (http://support.microsoft.com/?kbid=830466)
> says to contact microsoft customer service. When I ask for
> free online support it asks for the product id. When I try
> to check where the pid is, it's not listed. Our licenseing
> folks have no idea what our pid is for sql server.