Showing posts with label linux. Show all posts
Showing posts with label linux. Show all posts

Wednesday, March 28, 2012

Load balancing in SQL Server

We are doing a feasilibility study of using SQL Server cluster for load balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various nodes,
then Federated server is a better option. Can anyone explain this. Did I understand
it correctly.
I tried to find information about this in books online, but couldn't find it.
Were else can I get the information.
TIA.
SQL Server clustering is not for load balancing. It's for high
availability. Using federated servers is for load balancing. Check out
distributed partitioned views in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"rkusenet" <rkusenet@.sympatico.ca> wrote in message
news:c49pju$2g12jc$1@.ID-75254.news.uni-berlin.de...
We are doing a feasilibility study of using SQL Server cluster for load
balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using
JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems
that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various
nodes,
then Federated server is a better option. Can anyone explain this. Did I
understand
it correctly.
I tried to find information about this in books online, but couldn't find
it.
Were else can I get the information.
TIA.

Monday, February 20, 2012

Linux user: creating databases

Hi all.
I just installed MSSQL 2005 Express but I can′t find a sql client I can use to create databases.
Do I have to download it or it′s placed somewhere on my HD?
The only tools I see are placed at Start > Programs > Microsoft SQL Serve 2005 > Configuration Tools
Sorry about the dump question. I come from a linux background and everything seems to be different!
Cheers.
The download for the Express Edition does not include a GUI tool for managing the database. We have posted a pre-release version of the free management GUI tool - Management Studio Express Edition on the web for download. You can get it at: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en.

You can also download the documentation for Express at http://www.microsoft.com/downloads/details.aspx?FamilyID=9697aaaa-ad4b-416e-87a4-a8b154f92787&DisplayLang=en.

Out-of-the-box Express includes a command line tool SQLCMD for working with the installation (creating databases, creating tables, etc.) You can read more about it in the documentation.

Good luck.

Dan|||Hi Dan. Thanks for your quick reply!
In the meanwhile I downloaded the trial version (~900mb, outch!!).
How do I import ddl files into a database (trial version)?
Can I do it using theManagement Studio Express Edition too?
Cheers!
|||You can execute your sql script using SQLCMD.exe (from the command line) or using the Management Studio Express GUI.

Linux SQL Server Client

Hi,

Does Microsoft provide SQL Server Client for Linux, specifically SLES 9 64 bit? If none from Microsoft, any suggestion for third party package of SQL Server Client for SLES9 64bit? Thanks

Weidong

Microsoft provides a JDBC driver that will allow you to connect from a variety of operating systems - you can find the home page at http://msdn2.microsoft.com/en-us/data/aa937724.aspx.

Note that from the system requirements page at http://msdn2.microsoft.com/en-us/library/ms378422.aspx, it's stated that Sun Solaris, Red Hat Linux and Microsoft Windows 2000 or later are the officially supported operating systems.

Linux Servers(Verified)

Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith

I am guessing you mean do we have a driver that works apps on Linux machine to access SQL Server. Currently, we have JDBC driver which can be used on any machine with JVM installed to access SQL Server. The distribution of Linux doesn't matter as long as JVM 1.4 and later can be installed on the machine.

HTH

Linux Servers(Usage)

Hey Guys - I was just wondering - if at work you have started to use
Linux Servers - and if so, which Distribution of Linux and for what
purpose. Cheers - Mark Smithmark_smith (bhuta.darshan@.gmail.com) writes:

Quote:

Originally Posted by

Hey Guys - I was just wondering - if at work you have started to use
Linux Servers - and if so, which Distribution of Linux and for what
purpose. Cheers - Mark Smith


Whatever the purpose might be for running Linux, it is certainly not
running MS SQL Server (which is the focus of this newsgroup), as it
only runs on Windows.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Wed, 06 Jun 2007 01:04:05 -0700, mark_smith

SQL Server does not run on Linux (yet as I believe it is just a matter
of time because when the RDBMS only runs on one platfrom it cuts
marketing prospects) so you are on the wrong group.

However, I will tell you what I do.

We run Oracle, DB2, and SQL Server 2000,2005 applications.

We have Oracle 10gr2 talking on RHEL4. It works well. The application
is Java based.

<bhuta.darshan@.gmail.comwrote:

Quote:

Originally Posted by

>Hey Guys - I was just wondering - if at work you have started to use
>Linux Servers - and if so, which Distribution of Linux and for what
>purpose. Cheers - Mark Smith

Linux Servers (Usage)

Hey Guys - I was just wondering - if at work you have started to use Linux Servers - and if so, which Distribution of Linux and for what purpose. Cheers - Mark SmithHey Guys - I was just wondering - if at work you have started to use Linux Servers - and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith
I was just wondering, what the heck has this to do with Microsoft SQL Server? :)|||you just need to use the open source MSSQL jdbc direct drivers from the open source project on sourceforge. http://jtds.sourceforge.net/

Linux Servers

Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith

Mark_Smith111 wrote:

Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith

I don't understand this question... What are you asking, exactly?

SSIS won't run on Linux. SSIS can connect to Linux using a variety of tasks, though some of them have issues as well (FTP Task, for instance.)

Linux Server(Verified)

Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark SmithHey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith

Are you kidding me? Trying to be funny or are you just spamming the forum?

SQL Server is a Microsoft product. Have you ever heard of any Microsoft products running on Linux? No my friend, SQL Server runs on Windows only.|||Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith
It really depends on your definition of along with. As kaffenils said, you cannot run MSSQL on a Linux box. What you can do however is running SQL Server on its own server, and then use that server in a mixed environment. You may for instance have Apache/PHP sites that makes use of MSSQL, and if desired you may use SQL Server Integration Services to make integrations between various databases running on the Linux platform, as for instance DB2, Oracle, PostGres and MySQL.