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 aggregate multilingual Data

Hi All,
I have three database servers which are german, english and french each
stores data in their localized formats of values like 1000.85 in english
1.000,85 in german and french but i have to get these data and aggreate the
results and display a report.
Can any one help regarding how to aggregate localized data and display a
report say in english.
Regards
enzeekayIf your problem is how to get the data from three different servers to appear
in one result set, then the answer is: Use linked servers. On the English
server, create a linked server for each of the other servers. Look in SQL
Server Books Online for how to do this.
You can then do queries like:
SELECT Product, SalesRevenue*BritishExchangeRate FROM MyEnglishTable
UNION
SELECT Product, SalesRevenue*EuroExchangeRate FROM
MyFrenchServer.MyDatabase.dbo.MyFrenchTable
UNION
SELECT Product, SalesRevenue*EuroExchangeRate FROM
MyGermanserver.MyDatabase.dbo.MyGermanTable
I have assumed that it is better to do the conversion rates at the SQL
Server end, but you could also do it in Reporting Services.
The number format is not important. There is only one internal format inside
SQL Server; the fact that when the numbers display, French use a period for a
thousands separator and a comma for a decimal is immaterial. That is just how
the number displays on a French system. The same table copied to an English
system will display accordingly.
HTH
Charles Kangai, MCT, MCDBA
"Girish Kumar" wrote:
> Hi All,
> I have three database servers which are german, english and french each
> stores data in their localized formats of values like 1000.85 in english
> 1.000,85 in german and french but i have to get these data and aggreate the
> results and display a report.
> Can any one help regarding how to aggregate localized data and display a
> report say in english.
> Regards
> enzeekay
>sql

How Can I add a linked server with IP address only(Not server name)

Hi, there,

I am try to add a linked server to one of my server. the problem is, those two servers are not on the same network. I have to put in IP address as linked server name. I added the server OK, but when I do the query, I have to put the server name in the query, which caused error.

say the IP address of the linked server is 64.253.133.100
the query looks like,

select * from 64.253.133.100.databasename.dbo.tablename

Is there any way I can add the linked server with IP address at all?

Thank you

Jack

You can keep the linked server name different from the actual server name (which you are refering to as IP). Use this
EXEC master.dbo.sp_addlinkedserver @.server = N'LINKEDSERVERNAME', @.srvproduct=N'SQLNCLI', @.provider=N'SQLNCLI', @.datasrc=N'64.253.133.100'
Use master.dbo.sp_addlinkedsrvlogin to set the appropriate login/password.

Thanks,
Kuntal

|||Kuntal

Thank you so much. It worked.

Jack

How about getting a dedicated server to run and manage SQL jobs

Hi all:

Give me some feedback.

In my company, we have 10+ sql servers and many sql jobs running on every SQl server.

What about the idea that running all jobs on a dedicated sql servers?

at least 2 advantages

1.easy to managment

2.if agent server down, we restart the server not to impact the downtime of the production server.

any suggestion is welcome.

We had a similar setup which worked well.
Basically had big machines for SQL server and then used blades for "distributed" SSIS jobs.
All you really need is fast procs, lots of memory and not much disk space.
The idea was that as one box would become loaded, we would introduce another. All boxes would have the same jobs on it, but some disabled. The packages were run from a network location so should a box die, we can switch over quite quickly.

The issues are:
Licensing
Network performance
Cost

But if those are not a problem, it is a nice solution.

Hosting Companies

My company is interested in using Reporting Services but doesn't yet want to
commit to their own servers. Does anyone know of any hosting companies
offering hosting of SQL Server Reporting Services? So far, I can only find
one - discountasp.net and I'd like some more alternatives.infosaic.com
They are installing it this week. Sales may not be familiar with it as yet
so contact Garry Vershinin in tech support.
I have been hosting with them for three years now and am very happy with
their service and tech support.
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:8DC71D05-DAD3-4A87-A995-F78E183A7BC3@.microsoft.com...
> My company is interested in using Reporting Services but doesn't yet want
> to
> commit to their own servers. Does anyone know of any hosting companies
> offering hosting of SQL Server Reporting Services? So far, I can only
> find
> one - discountasp.net and I'd like some more alternatives.