SQL7 User Scalability
Mar 10, 2000
Hello All,
I was just looking for some rough estimates on the number of simultaneous users that SQL7 EE can support in a Web (IIS/ASP) environment. I know there are a lot of configuration issues that will effect the answer, but assume that there are a couple of IIS servers running WLBS that need to connect to the SQL database for query and update functionality. Of course, all access to the database will be controlled through stored procedures. Any thoughts would be most appreciated...
Thanks,
Chris
View 1 Replies
ADVERTISEMENT
Dec 5, 2007
Hi,
Whats the best way to test scalability on a database? I'm working on a new app, and have handed off developing the database to someone with more experience. Some tables will grow to many million records, and I don't want it to bottleneck. I need to have it fully tested before it goes live.
Is it reasonable to ask the person helping me to fill it with 10's of millions of rows to test performance? Is this a decent solution? If so, what would the best way to fill it be? If not, what steps should I take?
Thanks very much!
mike123
View 2 Replies
View Related
Jul 23, 2005
Could someone out there please help me to answer these questions?Thanks in advance.1. What aspects of SQL Server allow it to reliably scale up to supporta large global enterprise? And, when does SQL Server reliabilitybegin to fail?2. Given a role-based security model and without doing a benchmark,are there potential performance issues of using a SQL Server database ?How would this change if more of the security was moved to theapplication level or moved to the database?3. How does SQL Server manage access to data at the record and datafield level?4. w do support and administration requirements compare between SQLServer (or MSDE) and Oracle? Consider levels of expertise needed fromcentral server to desktop implementations.
View 1 Replies
View Related
Feb 14, 2007
hi all
i want to know that how much performance of ssrs will be vary when i m installing ssrs on same machine where my database is stored, or when i m storing ssrs on different machine and database on different machine.
View 3 Replies
View Related
Nov 7, 2006
Hi, I'm looking for some recent surveys on the performance of ETL-Tools including SSIS and relates it to other ETL-vendors. Any ideas where to find valid stuff?
S.
View 1 Replies
View Related
Nov 23, 2005
I am trying to find some information on recommended deployments, preferably with a diagram for a presentation.
View 12 Replies
View Related
Dec 5, 2007
Our databases were working fine in terms of performance until over the last 2 months wherein the timeouts and deadlocks have started increasing. We are having growing clients with huge real-time transactions. We have been adding NOLOCKs on queries that are being used frequently etc but the timeouts are still an issue. Not sure what the best way to identify problem areas is. The CPU utilization has also been on the higher side. Profiler identified long queries are being indexed etc. But the performance is still a concern. Any ideas? What am i not looking at? HELP HELP..
Thanks,
Sri
View 16 Replies
View Related
Feb 28, 2008
I understand mount points help scalability in easier maintenance.
By scalability do we mean more than 26 drive letters or it means adding more space to the same mount point letter on with more ease .
Can I add more space to a mountpoint if required later on by adding hard disks .
Also if one can give some pointers to good file group configuration guidelines / storage align partitions , it will be very much helpful
Further I my server CPU has 4 cores , will having 4 filegroups help me in improving system performance.
If SAN has 2 controllers , is it preferred to run data file partition on one controller and log file partition on another.
Thanks in advance.
View 1 Replies
View Related
Jul 12, 2006
We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big.
We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run.
We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany.
Or maybe database partitioning by language???
Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main database and maybe 2 (Spanish and German) €œsatellite€? databases or something like that €“ any ideas???.
Any suggestions of how to deal with this problem the best way would be greatly appreciated. We are using SQL Server 2005.
Newbie!
View 4 Replies
View Related
Jun 16, 2006
We are beginning to design a new application with SQL Server 2005. Our current production environment is slated to be two SQL Server 2005 machines with the databases residing on an EMC SAN. We have requirements to both have automatic failover between servers for availability and also be able to balance the load over two hot servers for scalability.
Can anyone point me in the right direction for things I need to consider in order to be able to implement both of these requirements? Can I implement database mirroring (for failover) and transactional replication (for balancing) given the hardware configuration I'v mentioned? Is more information needed? Where should I turn next?
I am coming off a mainly Oracle background for the last ten or so years with a smattering of SQL Server mixed in. I've tried to hit the ground running on this project, but sometimes find myself hitting the wall running instead.
Thanks,
Larry
View 3 Replies
View Related
Jul 21, 2000
We have a high load site that requires some redesign. We would like to move the PK generation from a custom scheme to IDENTITY columns.
What are the any scalability issues for using IDENTITY? Will contention issues arise because of row locking?
Thanks in advance.
View 7 Replies
View Related
Jan 25, 2006
Hi,First I would like to apologize for cross posting in three groups asI did not know which one would be the appropriate group. If some onepoints me to the correct one I will use that in the future.I am trying to findout the scalabilty of an user written extendedstore procedure. I have created a dll using a C program(modified/plagarized from some of the examples) . The main function ofthis extended SP is to act as a passthru to connect to an third partyODBC driver. All this is supposed to do is take the passthru sqlstatement, userid, passsword and connect to a remote server (IBM 3090Mainframe in our case) using a system ODBC connection and pass thereturned result set back to the stored procedure calling this extendedSP. I am trying to find out the answers for the following questions.1. What are the limitations of this approach.2. What would happen say if 2,000 concurrent calls per minute are madeto the extended SP from the web app.3. What would happen if this continued for say 4 hours. Will the memoryusage increase to point that will cripple the server assuming there isno memory leak in the dll.4. Are there any connection pooling concerns that I should payattention to specifically from an Extended SP point of view.5. Apart from compiling the dll using the "MultiThread" option should Ibe using other options to make sure the dll is threadsafe.SQL server Environment :OS - Windows 2000 Advanced Server SP4SQL - SQLServer 2000 Enterprise edition SP3Hardware - 8 way 2 node cluster with 6Gb RAMAny help regarding this is greately appreciated.Prahalad
View 3 Replies
View Related
Dec 5, 1998
How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.
View 6 Replies
View Related
Dec 7, 2006
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
View 3 Replies
View Related
May 22, 2008
Hi,
Please give the T-SQL script for this ? Thanks
Shanth
View 4 Replies
View Related
Jul 16, 2000
Hi there,
After installing SP2 we encounter a problem with MMC. When selecting a DB we recieve a RunTime error? And the DB items/properties are not shown.
Is there anyone with the same problem and knows how to fix this? I search the MS site for more information but there is nothing on it.
Danny
View 1 Replies
View Related
Apr 17, 2000
Is MS SQL 7.0 have any difference/incompatibility problem with the BackOffice's SQL 7.0?
anybody can clarify this to me please... tq!
View 2 Replies
View Related
Feb 11, 2002
I am going to install SQL7.0 on the current NT4.0 with SQL6.5 on it by uninstalling SQL6.5 first and then installing (not upgrading through Wizard) SQL7.0.
Here are the questions I need help with:
1. Should I convert the database after the installation of SQL7.0 or directly restore the SQL6.5 databases backup?
2. If I need to convert the databases, How and in what way?
3. Which way is better upgrade or installation?
Thank you ahead of time
John
View 2 Replies
View Related
Apr 2, 2001
I am looking for documentation/information on how to configure SQL7 so that I
can use SMTP for delivering e-mail.
I have other applications which use SMTP for delivering our e-mail.
I don't have Exchange. Internally we use GroupWise for our mail system.
Thanks in advance!!!
View 1 Replies
View Related
Jul 11, 2001
Current system 2 x 500mhz pIII 512MB ram, System mirrored and data raid 5 30GB made from 3 disks. All server is running in CA TNG. an Asset management DB and Software Delivery database. But the poor server runns most of the time at 100% 65% being used by SqlServer process. Does/Can anyone recommend any tweaks upgrades that may let the server take a breath in and out ie will more memory speed thing up faster processors or more disk.
Thanks
Nigel
View 4 Replies
View Related
Sep 27, 2001
Hi,
i'm brand new in the sql server world so maby this is an easy problem.
I have to get data from AS/400 to SQL7. I've created a package with a client acces odbc driver and an sql driver which transfers the data of an entire table. When i execute this it works fine.
Now i want to shedule this (shedule package). When i start this job it doesn't work.
This is the error i get:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 5 (5) Error string: [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x5 Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
on the server i've installed client access as well and created the same odbc driver (with the same name). But it still doesn't work.
Can anybody help me please??
View 1 Replies
View Related
Oct 12, 2001
I have a database on a 6.5 server but wish to upgrade this database to a sql 7 database. But I would like to test this first on another server which is a sql 7 server. Is it possible to restore a 6.5 backup to a SQL server 7.0 server?
Thanks in advance..
View 2 Replies
View Related
Jul 21, 2000
Is there a way to list all the tables in each of the filegroup
in a database. I have a database with 7 filegroups and would like
to have a list of tables in each filegroup
Sp_helpfilegroup gives you list of filegroups and the names of files
View 1 Replies
View Related
Jul 25, 2000
hai,
i unable to import/export from sql7.0 database to text file in windows 98 system . can anybody help me ?
View 2 Replies
View Related
Jan 4, 2001
I recall seeing something about an extra / additional / enhanced / second version of Help that is available after installing SQL7 SP2. Does anyone know anything about it, such as where to find it? Thanks.
View 1 Replies
View Related
Aug 11, 2000
I need some documentation on how to trouble shoot clustering SQL7EE. I have setup the cluster and looks like it is working but I missed somthing. When I test a failover by pulling the Network cable to the main network not the heartbeat network both boxes lock up. I can failover by powering down one box and using the MSCluster Admin. I am using NT40 6a on Dell PowerEdge 2400 and PowerValut 211s
View 3 Replies
View Related
Sep 17, 2000
Hi folks. Got a real doozy going. One of the network techs reinstalled NT4 SP5 on a server. This reverted the SQL driver back to 2.something. Now sqlserveragent jobs will not run.
I have tried to instal MDAC 2.5, but it doesn't change the driver up to the new 3.xxx driver. I searched around on here and folks said that you have to move the MDAC executable to a new directory. for the new MDAC I don't see MDAC.EXE. I did find MDAC.COM and renamed that. Tried to rerun MDAC 2.5 but still got the old SQLSRV32.Dll.
Uninstalled SQLServer and reinstalled. still got the old SQLSRV32.Dll.
Tried to apply SQLServer SP1. It died.
Found that I am to shutdown some services. Did that. SP1 still dies.
Tried to apply SQLSERVER SP2. It tries to pick up where it died and it dies again.
SO, I'm currently uninstalling SQLServer, reboot, installing SQLServer, reboot, Trying SP2 again.
Didn't think that it was brain surgery just to install a new flippin version of the ODBC driver.. SHEEZ!!!!
View 4 Replies
View Related
Mar 6, 2000
Does anyone know of a sp similar to sp_helprevdatabase (SQL 6.5) for SQL 7.0? Will I need to use SQLDMO or can I use DTS somehow.
Thnxs.
View 2 Replies
View Related
Mar 4, 2000
I am using ASPs in my VB6 script to call an SQL 7 database. What security issues shd be considered? How will the IIS security be handled with NT4 & SQL7 security?
Any suggestions wld be highly appreciated!
Thanks in advance!
Adie
View 1 Replies
View Related
Apr 3, 2000
Starting with Win2k you are not suppossed to have to install MDAC, as it comes with the OS. What about when I install SQL7 and it automatically installs MDAC. Do I have to reinstall MDAC in this case?
View 2 Replies
View Related
Mar 27, 2000
This is a very confusing question. Let me start:
I need to know can I use Japanese characters in SJIS format with American SQL 7 on Win2K. I must be able to integrate a Japanese language database and an English language database on one platform. Since most people working on this project are bilingual, it would be OK to get Win2K Japanese. But I am not sure how to get SQL Japanese in the states, where I am working now.
Can you helP?
Thanks
Taisho
View 2 Replies
View Related
Nov 17, 2000
I need to backup my sql7 through the network share.
I have two servers both have SQL7 and only one has a backup tape drive (which is my production database). I want to be able to backup to the tape and to the a share drive on the second server. The backup to the tape work fine but if I want to backup to share drive locate to the second server I can't see the share where I want to put the backup. Do you Know what I am doing wrong ?
Thanks.
Mtraore.
View 1 Replies
View Related
Nov 17, 2000
I need to backup my sql7 through the network share.
I have two servers both have SQL7 and only one has a backup tape drive (which is my production database). I want to be able to backup to the tape and to the a share drive on the second server. The backup to the tape work fine but if I want to backup to share drive locate to the second server I can't see the share where I want to put the backup. Do you Know what I am doing wrong ?
Thanks.
Mtraore.
View 2 Replies
View Related
