Hi
This is more a product featuer question which I cant seem to find the answer to
If we wanted to share the loads of SQL Server requests over say 2 or 4 servers, is this possible?
What I mean is basically Active/Active load balancing / clustering? So we have one Virtual IP and all requests are forwarded to the least busy server.....
J
i have a table with 10,000,000,000 records and i need Select and Insert many
records from or into this table in less than one second.
i can't buy a very expensive hardware(Server) for this SQL Server 2005
but i can buy many medium price hardwares(Servers) for this SQL Server
2005.
how can i distribute or cluster this table between many hardwares(Servers)?
note: i have few users (maximum 5 users) for my database but i have a
very large table and Sql server 2005 server need to respond to this
users in less than 1 second.
i want to distribute this huge table in seperated hardwares. becuase i
can't buy a very expensive hardware from my server but i can buy many
medium price hardware for my server.
note: i need this: when a user run a select query on this huge table
his/her request distribute between many hardwares not one hardware.
Currently we have a single SQL server. It went down and the higher ups were none to happy. Lots of money lost, down time, unhappy customers....the whole nine yards. They want to throw all sorts of money at the problem and want a solution that is high availability and provides load balancing. I think I came up with a solution.
3x Windows 2003 Enterprise Edition servers running SQL 2005 Standard in a cluster all connected to a SAN.
I'm guessing I need to set up Network Load Balancing in order to load balance the SQL database. What we would love to have happen is if one of the servers goes down, everything else just picks up. That coupled with our database that is increasing in size and transactions gets load balanced.
Am I going down the right path? Something else I should look at? Or that I am missing?
Thanks!
Currently we have a single SQL server. It went down and the higher ups were none to happy. Lots of money lost, down time, unhappy customers....the whole nine yards. They want to throw all sorts of money at the problem and want a solution that is high availability and provides load balancing. I think I came up with a solution.
3x Windows 2003 Enterprise Edition servers running SQL 2005 Standard in a cluster all connected to a SAN.
I'm guessing I need to set up Network Load Balancing in order to load balance the SQL database. What we would love to have happen is if one of the servers goes down, everything else just picks up. That coupled with our database that is increasing in size and transactions gets load balanced.
Am I going down the right path? Something else I should look at? Or that I am missing?
Thanks and sorry for posting this in multiple places!
Environment: Windows Advanced Server with SP2. SQL 2K Enterprise edition with SP2.
There are three disk drives in my shared array named E:, F:, and H:.
When I use EM (Enterprise Manager) to create a job (like a backup job), the drop down box contains only drive F:.
Drive F: was the drive specified during the install process for data files.
Drive C: and D: also exist. Drive D: was specified during the install process for the program files.
It seems to me that drop down boxes in EM which show disk drives should actually show me the following drives: C:, D:, E:, F:, and H:.
Any ideas why EM may not be showing all the disk drives.
TIA solart
I appologize if I am posting this msg twice (newby), but I am getting this error msg in the app log.
MS DTC setup failed to populate the shared cluster
registry. The DTC resource will not be able to come
online.Error Specifics:
d:srv03rtmcomcomplusdtcsharedmtxclumtxcluse
tuphelper
.cpp:120, CmdLine: "C:WINDOWScluster
esrcmon.exe" -e
1208 -m 1212 -p 2132, Pid: 3636
Have anybody seen this msg and any ideas on what to do in this situation? Your timely assistance is much appreciated. Thanks,
I'm looking at using Cluster Shared Volumes on a new Windows Server 2012/SQL Server 2014 cluster. Each instance is going to be configured to use cluster shared volumes. Is there any reason why Availability Groups couldn't be used in conjunction with Cluster Shared Volumes.
View 4 Replies View RelatedIs there a way to get access to the files on the shared drive from either of the nodes when the SQL Cluster is shut down?
It doesn't look like there is, but hoping there is some trick. I see how it can be done with a Windows Cluster but not a SQL Cluster.
need the concpet of load balancing cluster ?can any one help me out with any link....?
View 1 Replies View RelatedHey guys,
Lately we have come across a problem where our application is undergoing some extreme load against the SQL 2000 server database we have setup, where the server is hitting 100% CPU utilization each time. Currently the box is a 2 processor box.
Here is the question I have. I have seen under most SQL Server clusters that an active/passive setup is implemented. Where the passive server just exists as a failover mechanism. What I am looking for is some information on how to setup active/active setup where each server receives processes to handle.
Has anyone created a setup like this? Are there any standard benchmarking tools that can be used to see how this configuration increases performance? Is this setup more favorable than going to a 4 processor server as oppossed to our current 2 processor server?
BTW: We have noticed that after a web application where the user sits idle for a while the SQL Server application loses the connection with the application user...Is this the SQL Timeout causing the connection to disconnect?
Thanx for any response...
Bri
Is there such a thing called 'Load balancing' on fail over cluster?
View 2 Replies View RelatedI am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.All of my 2005 databases back up successfully.They all restore without issue except for one database that has a full text catalog. I get this message
Msg 7610, Level 16, State 1, Line 2
Access is denied to "fileStoragedataMSSQLSERVERFullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to 'fileStoragedataMSSQLSERVERFullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
[code]....
I went as far as giving the folder full access to everyone temporarily and received the same error.
HI,
currently two people(with different username and password) are using a shared workstation, where in the sql server is installed. so i just wanted to know that whether two people could use the sql server at the same time. please note that the two people have different username and password to enter to log in.
Thanks,
Nitin
Hi
We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.
Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?
Thanks
Priyanka
My hosting gives me ASP.NET 2.0 and a shared SQL Server 2005 package.
I have Visual Studio 2005 on my machine - which installs SQL Server 2005 Express. I have also installed SQL Server 2005 Management Studio Express.
I wish to develop my database locally (mdf file) as I won't always have internet access (and therefore can't always work directly with the remote shared database).
My question is, how do I upload my database info from my local machine to my remote shared database?
Also I shall wish to download my remote database to my local machine in order to work on the database (and then be able to re-upload it) sometimes.
Please can somebody tell me how I can do this?
Will SQL Server 2005 Management Studio Express permit me to do this and if so how?
If I need the full version of SQL Server 2005 Management Studio then I do have SQL Server 2005 and this install with it (but it all looks a bit complicated to install for me).
Many thanks for all help given,
Graham
Hi,
I'm trying to get the External Activation Sample to work on a shared hosting Sql Server. The error seems to indication that I might be able to enter my db un/pw to get it to work. Where in the code or app.xml can I provide credentials? Here's the EA log. Thanks!
3/29/2007 4:47:39 PM STATUS: External Activator initialization completed.
3/29/2007 4:47:42 PM WARNING: Failed to connect to Notification SQL Server 'sqlb2.webcontrolcenter.com' and Database: 'xyz' because: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
3/29/2007 4:48:17 PM STATUS: External Activator is shutting down...
Stacy
We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.
What we were thinking was the following steps... Anyone try this?
1. Break the link between the servers.
2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.
3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.
4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
Thoughts?
Friends -
Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.
Let me explain my current environment.
1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.
My Plans:
1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.
2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.
My doubts
1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.
Please advise me and correct my steps.
Cheers
VSH
Hello,
I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.
Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?
Does loading 2000 backup create 2005 binary structure?
Thanks for help in advance
Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?
View 3 Replies View Related
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
Hi,
I want to backup and/or have a local copy of my DB which is on a shared host. I have an ip addreess and user/pwd, but I am at a loss to find any help for the steps to accomplish this in Management express.
Am I using the right tool?
Hi, I've read from a topic in this forum saying that we could store PDF files in a hard drive location and import the link into a table of database in SQL server 2005, but i don't know how. So I really appreciate if someone could show me how to write a store procedure or a scripto to do this?
And by the way, i have another question. From that PDF files link, is there any way that we could call that pdf files and print that files from SQL script or SQL store procedure. Thanks a lot
Nick
Initially I loaded SQL along with C# however it said at the time that the load had been unsuccessful. I continued as I knew I wouldnt need SQL for a while.
I also have Web Developer loaded and this would not load SQL 2005 Express either.
I have tried loading SQL 2005 Express as a seperate download and I note that rollback occurs - I presume because of the COM+ warning that appeared. I have been through the 'Work around COM+ System Configuration Check Failure in SQL Server Setup' document - to no avail. The following parts of SQL that have not loaded:
SQL Server 2005 Database Services.
I have also tried deleting all components of Visual Studio 2005 Express Edition and loading SQL as the first component; that also failed.
I have saved the logfile, however I dont really know what I'm looking for. sqlActionManaged = 3, sqlStateManaged = 2.
When I run sp1 on the active node of a 64-bit cluster the setup just hangs when it gets to the Database services part. It does not return any errors as mentioned by others in this forum. I also do not have SqlSupport.msi in the add/remove programs (one suggestion on this forum was to uninstall it reinstall). I have let it run for up to 12 hours with no result.
There is no SQL9_Hotfix_KB913090_sqlrun_sql.msp.log file only SQL9_Hotfix_KB913090.log
this is the content
05/09/2006 12:41:12.274 ================================================================================
05/09/2006 12:41:12.274 Hotfix package launched
05/09/2006 12:41:15.634 Product discovery successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 SP Level check successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 Product language check successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 Product version check successfully completed during the install process for DEV01
05/09/2006 12:41:15.681 Product discovery successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 SP Level check successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 Product language check successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 Product version check successfully completed during the install process for DEV02
05/09/2006 12:41:15.743 Product discovery successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 SP Level check successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 Product language check successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 Product version check successfully completed during the install process for DEV03
05/09/2006 12:41:15.790 Product discovery successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 SP Level check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Product language check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Product version check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Command-line instance name check completed during the install process
05/09/2006 12:41:15.868 Baseline build check completed during the install process
05/09/2006 12:44:25.795 Attempting to install instance: DEV02
05/09/2006 12:44:25.795 Enumerating passive cluster nodes
05/09/2006 12:44:25.873 Patching available passive node: TTCSQL62A
05/09/2006 12:44:25.873 Waiting for first successfully completed passive node
05/09/2006 12:44:25.873 Attempting to patch running passive node: TTCSQL62A
we want to have an activepassive and active passive cluster.
node a install sql instance 1 failover over to node b
node b install sql instance 2 failover to node a
do I have to setup 2 cluster ? ie. quorum, msdtc etc..
or just one cluster(quorum, ip and name), one msdtc group( as per MS msdtc doc) and 2 san disks (one for node a and one for node b.
is this correct? I have looked and looked for a step by step on setting this up, no where can I find what i need. I downloaded the failover cluster doc from microsoft, book online etc..
thanks
quick overview
2 nodes-cluster setup from node 1
I setup a cluster, created 4 groups
1.cluster 2.msdtc 3.sqlinstance1 4.sqlinstance2
I want to create an activepassive on both nodes. (onenode will be the active node for on sql install while the other is passive.
I want to repeat this fo rthe second node, the second node being active and node 1 passive.
I logged into node 1 and I installed sql 2005 in failover cluster into sqlinstance 1., everyhting was fine, failover etc.
Now I logged into node 2 and ran sql 2005 setup to create a failover cluster.
I chose to install into sql instance 2.
Database unable to install with error "failed to set registry settings for server network libraries. acition is setdefaults.error 11001, no such host is known.
If I am not setting this up correclty please let me know
thanks
everything was fine. I logged onto node 2, was going to
I'm having trouble finding the recommended process for doing a full Disaster Recovery on a two node active/passive sql 2005 cluster. I've been able to locate the procedure for rebuilding a failed node on the msdn site but no procedure for recovering the entire system. Any assistance or points in the right direction are appreciated.
Thanks
Hi guys
I have just recently inherited a sql server 2005 cluster (2 nodes) we have a situation coming up where i need to power down the whole cluster for several hours as a result of some power mains work.
I just need to confirm with someone the correct way to power down the whole cluster and power it back up once the power is restored the company. I appreciate this may not be the best place to have posted this but i am desperate and couldn't find another location.
many thanks for any help
SB
Anyone know before I invest in the hardware if it is possible to have Two Clusters on the same hardware both in Active/Passive Clustering where Cluster1 and Cluster2 both use the Default SQL Server 2005 Instance (No Named Instances)?
This would be a Virtual Cluster with Two separate 2 node Clusters on the Same Hardware sharing the same OS and SQL.
Thanks in Advance,
Best,
JD
hi
i have a dbf file which i need to import in sql server 2005.
anyone having any idea to import these files either through integration services or any other tool ???
Hi There
I have not had much luck finding info in BOL for tsql or SSIS that tells one how to load images on the file system into sql server 2005.
All i have really been able to find is that IMAGE data type will not be used in future and that one should use a varbinary(max) data type.
I am thinking of using a for each file loop in SSIS, but then how do i load the images (.tif) into a sql server database table ? Perhaps i need to use a sql task with the filepath , or an active x script.
Anyway if anyone knows how i can load images from the file system into sql server 2005, please let me know.
Thanx
My company is planning on using a datacenter for our customers. These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server)
View 6 Replies View Related