Hi Friends,
I am Gokul, I am using SQL Server MSEE 2005 (Free ware). Currently I am involved in the development of an application where I am using SQL Server MSEE 2005 and VB.Net. My incomming data size ranges from 5 GB to 7 GB per day. Can I use SQL Server MSEE 2005 as Data base with any licensing or have to get any license for storing larger capacity data.
Can any body please help me.
Thanks,
Gokul.G
I am just starting to build my apps in asp.net 2.0. I have build apss in v. 1.x before using sql server 2000. However, before i make the shift, I would like to know the advantages and disadvantages of using the sql server 2005 express edition then using the sql server 2000.
for example;+ How many data can it store?+ How many concurrent users it supports.+ Advantages and disadvantages of using sql server 2005 express ed.+ Any other relevant information that developers should know / beware / watch out for when using sql server 2005 express edition.
Note: I am not asking about the actual SQL Server 2005 but the express edition!
Regards and thanks in advance
Hi Everybody:
4 -5 years ago, I started my career as a translator translating the MetaTexis CAT (Computer Aided Translation Software).
It's amazing to see all the improvements that have been made until now, but recently I found some problems regarding
databases:
I heard that ACCESS databases volume is limited up to 2 GB and that SQL 2005 databases volume is limited up to 4 GB, but I think this information is wrong, or at least I was only able to import 10% of that amount.
Speaking in words, 2 GB doesn't represent a database with a volume of 125,000 segments/sentences (for ACCESS) and 4 GB a volume of 250,000 (for SQL 2005).
Concrete, my "mega.mxtm" database has "only" 359 MB and suddenly I refuses to import more sentences. Is that normal? (MICROSOFT SQL 2005)
Question: Is the new SQL 2008 also limited? Is there any way to "free" or increase the volume capacity?
Point 2: As I updated the SQL 2005 into 2008 I am not able to open the "old" "mega.mxtm" anymore... : (
Regards!
De Sena Viegas
How to implement distinct storage tiers on SQL Remote BLOB Storage (RBS)?
I want to use this SQL Feature to move files(images, videos, pdf files) from a database to a distinct database dedicated to RBS. Then I want to have several storage tiers, where objects will be saved and moved according access frequency. Old data will be arquived in cheap storage, but it must be always accessible if needed.
Description:
- 1st and main tier: new and frequently accessed objects stored in high performance storage;
- 2nd tier: automatically move older or less accessed objects to an inexpensive and different storage tier;
- in all cases, all objects must be accessible to all users, but accessing to archived objects(2nd tier) will be much slower;
Hello,
I am designing a program for work with SQL Server express 2005. But I don't know what is the data storage limit in this version of SQL Server.
What i want is storing about 30000 records in a table of the database.
Hasn't SQL Server express 2005 any problem or restrictions for storing the data?
Please advice in this regards,
Thank you,
Mona
Here are my planning details:
RAID 1:
2 disks RAID 1 for OS and BINS
2 disks RAID 1 for Backups.
RAID 10
4 disks RAID 10 for data
4 disks RAID 10 for log
4 disks RAID 10 for TEMPDB
Should i put the master and other system database on RAID 10 along with TempDB.
Or what else a guru fellow will advise in above setup.
thanks,
Dear All
I have a situation where I installed SQL Server 2005 64 bit on a server, where database files are stored on storage media 'Sun StorEdge 3320 Storage'
I am facing deadlock problems, and slow performance, though they do not appear on my test environement (64-bit, server with no storage)
I need a method to track and find out the source of the problem, could be storage media compatibility, SQL Server or any other issue
Please find below specifications of the storage media used;
Sun StorEdge 3320 Storage
3.1.3.1 SE 3320: Technical Specifications
Model Sun StoreEdge 3320.
Manufacturer Sun Microsystems
Country of Origin Sun-certified factories in America€™s/ EEC/ Far East.
Manufacturing
Standards
UL, FCC, IEC, EN, ISO, etc.
Kindly refer to technical brochures provided for detailed numbers of
above standards.
Operating systems supported
Sun Solaris Operating Environments 8, 9, 10, SPARC Platform Edition
Solaris 10 operating system, x86 Platform Edition
Red Hat Linux AS 3.0
Microsoft Windows 2000 Advanced Server and Windows 2003 Server
IBM AIX 5.1
HP-UX 11i
Novell Netware 5.1 and 6.5
SUSE LINUX Enterprise Server 9.0, (32-bit and 64-bit) Proposed Configuration
Expansion
Expandable Up to 3.6TB per enclosure and Up to 68.4TB of raw capacity per rack cabinet.
Supported drives are 73GB 10Krpm, 146GB 10Krpm, 300GB 10Krpm, 73GB 15Krpm, and 146GB
15Krpm and is expandable to support up to two 2RU expansion trays (36 drives total).
Proposed Configuration
Proposed with 365GB (5x 73GB Ultra 320 SCSI HDD)
Interface
STS AlertONE Technical & Financial proposal €“ Mobilecom
STS_Tech_Mobilecom_AlertOnet v 5 0.doc Page 38 of 73
CONFIDENTIAL© Copyright STS (2006) Stamp / Signature
320MB SCSI LVD
Ports and Controllers
Upgradeable to dual (mirrored) RAID controllers
All configurations have 2 Host ports
Management Software
All needed Management Software is included such as Sun StorEdge Configuration Service; and Sun
StorEdge Diagnostic Reporter software
Power and Cooling
Dual hot-swap, redundant, load-sharing power supplies with dual independent AC inputs
Hot-swap, redundant electrically-isolated redundant cooling fans
RAID Level Support
RAID 0, 1, 0+1, 3, 5, 3+0, and 5+0
LUN€™s
Up to 128 LUN€™s with LUN Masking [Security]
Server Controllers
2 x UltraSCSI adapters are proposed one for each server.
appreciate any feedback
thanks
Using shared folder in windows mobile 5 emulator, it is not possible to create a database (sqlserver mobile 2005) in the emulated storage card.
The error "sql mobile made an unsupported request to the host operating system. Minor Err 25133 is raised. Reading or writing file from/to the emulated storage card occurs without error.
Is this a bug of SqlCeEngine?
thank you
vincenzo
I am a Windows developer for the IBM Tivoli Storage Manager Server (TSMS) product.
Our product installation is built with InstallShield and uses the Windows Installer.
On a new installation of Windows 2003 x64 Storage Server R2, at a customer's site, the TSMS product fails to install.
The install of the OS has version 3.01.400.3959 of the Windows Installer and I see no newer version that installs.
Part of our product is 32 bit (console) and another part is x64 (server).
When installing I can see that the install's default is being redirected/reset to C:Program Files (x86)TivoliTSM after it is explicitly set by a custom action to ..Program Files.. . I further observe that our custom actions to write 64 bit registry entries are being refused.
REGSAM samMask = KEY_ALL_ACCESS;
if ( regIsWow64Process () ) samMask = samMask | KEY_WOW64_64KEY;
lStatus = RegCreateKeyEx( hLocalConnectKeyRoot,
szSubkey,
0L,
NULL,
REG_OPTION_NON_VOLATILE,
samMask,
NULL,
hKey,
&dw ) ;
The above fails to create the key.
We have tried four versions of our TSMS spanning many changes but the install acts the same.
This does not happen on any other Windows OS we test on but we do not test on Windows 2003 Storage Server R2 being that it is an OEM product. We did test on Windows server 2003 R2 x64 and do not see this problem.
Do you have any suggestions on how to tackle this problem?
I have full installation traces but can only see that the registry work is being refused. I can't see why.
Hi all,
I have created a small COM in C# so that I can programatically create and execute stored procedures with SMO. At this point the COM has nothing in it but just a test prototype.
But when I tried to create the object as follows, I get the error indicated below.
It is not a memory issue because I have adequate storage and RAM.
Please Help!
DECLARE @object int
DECLARE @hr int
DECLARE @property varchar(255)
DECLARE @return varchar(255)
DECLARE @src varchar(255), @desc varchar(255)
-- Create an object.
EXEC @hr = sp_OACreate 'SQLInterop.CsharpHelper', @object OUT
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
RETURN
END
This is the error I am getting:
Error Code: 0x8007000E
Description: Not enough storage is available to complete this operation.
Source: ODSOLE Extended Procedure
This is the C# code for the COM:
using System;
using System.Runtime.InteropServices;
using System.Reflection;
using System.Runtime.CompilerServices;
using System.EnterpriseServices;
// General Information about an assembly is controlled through the following
// set of attributes. Change these attribute values to modify the information
// associated with an assembly.
[assembly: AssemblyTitle("CSServer")]
[assembly: AssemblyDescription("Test SQL .NET interop")]
[assembly: AssemblyDelaySign(false)]
[assembly: AssemblyKeyFile("MyKey.snk")]
// Setting ComVisible to false makes the types in this assembly not visible
// to COM components. If you need to access a type in this assembly from
// COM, set the ComVisible attribute to true on that type.
[assembly: ComVisible(true)]
// The following GUID is for the ID of the typelib if this project is exposed to COM
[assembly: Guid("ff35c6b4-81bf-47dd-9290-fcbbb49008d9")]
// Version information for an assembly consists of the following four values:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.0.1")]
[assembly: AssemblyFileVersion("1.0.0.1")]
// the ApplicationName attribute specifies the name of the
// COM+ Application which will hold assembly components
[assembly: ApplicationName("SQLInterop")]
// the ApplicationActivation.ActivationOption attribute specifies
// where assembly components are loaded on activation
// Library : components run in the creator's process
// Server : components run in a system process, dllhost.exe
[assembly: ApplicationActivation(ActivationOption.Server)]
namespace SQLInterop
{
public interface ITest
{
string SayHello();
string SayIt(String strMessage);
}
//[SecurityRole("RBSecurityDemoRole", SetEveryoneAccess = true)]
[ComVisible(true)]
[CLSCompliant(false)]
[ClassInterface(ClassInterfaceType.None)]
public class CSharpHelper : ITest
{
public string SayHello()
{
return "Hello from CSharp";
}
public string SayIt(String strMessage)
{
return strMessage + ": from CSharp";
}
}
}
Hi,
any1 know how many records can be stored in a table in sql server? is there any way to maximise it? will table capacity (number of records) vary due to our table stucture or database structure? is there any documentation bout tis?
Cheerslife's Ng
hi, can any one tell me what is the meaning of capacity planning and where do I get info about it,and how does this help me in sql server admin role
thanks
Ahmed
What si capacity planning?
Where can i find more stuff on it?
Hi Everybody,
Our development team is doing some stuff in ASP. They are interested only in char and varchar
data types. They clearly told us that they are not going with text and image data types.
Is it possible to make a row size behind 8060 bytes in a table without text and image data types?.
tks in advance,
Sri.
Hi!
I got two questions and please forward all your suggestions:
1: Is there any document for capacity planning of SQL Server 6.5 database?
2: Is there a way to find out total number of transactions per day in SQL Server?
Thanks in advance!
Hi Everybody,
Can anybody explain me, what is Capacity Planning and what is Load Balancing?
tks in advance
sri
I have a flat file with about 2000 fields and 2 million records. I can reorganize the data any way I want and have a unique id field for each record.
Is SQL Server a suitable solution do you think, and also how many fields will a table take (I think access takes 255)?
If you think there may be a better solution for me to look at I would be glad to hear.
Thanks for any help
Hi All,
We need to do capacity planning for our SQL server database server. Capacity planning is interms of CPU usage, Memory usage and disk usage.
Can anybody help me with how should I start and what are the guidlines to do it? I have started executing perfmon utility with some counters but still not sure what to do next. Please help me. Thanks in advance.
Regards
Sachin
Don't sit back because of failure. It will come back to check if you still available. -- Binu
Hi ,
We need to upload over 100 GB file into SQL Server using SSIS. I want to know whether SSIS can upload such huge file in to a table. If yes, How ?. If not is there any work around to achieve this.
Expecting some solutions ASAP
Thanks
Regards
Pandithurai K
Singapore
Hi,
I€™m working in a DWH project the source system have data from passed 30 years and the total number of records from the source system is 10 million.
I€™m need to do the estimation for the data base for the up coming 10 years of data.
As I can predict that the 30 year of data is 10 million then expected data for 10 years would not be more then 3 million.
The ETL tool I€™m using is SQL Server Integration services and the reporting tool is Business Objects.
Can any one guide me on the implementation plan, mean memory taken for ETL jobs (As SSIS use large amount of memory) database and business objects.
Hi,
I have a question to do..
can I install sql server 2005 express edition on a windows storage server 2003 R2????
Thank-you!!
MTV
I 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.
Hey - I know that xp_fixeddrives gives me the amount of free space on a drive. Is there a similar (xp) function that will give me the capacity of a drive??? Any help is appreciated. Even if you can just point me in the right direction. Thanx in advance. Billy
View 1 Replies View RelatedDoes any one know where I can locate a document or template for database capacity planning on the web? Any help would be greatly appreciated. thanks.
View 1 Replies View Relatedhello,
I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:
1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.
2. Does the developer need to purchase a seperate license for distributing the .sql file?
3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.
NOTE: No Sql Server Software will be installed on client machines.
In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?
Please, somebody can help me for the licensing information and also for the database size?
Thank you.
hello,
I dnt know if this is the right place. I'm sorry for that.
WEll, I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:
1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.
2. Does the developer need to purchase a seperate license for distributing the .sql file?
3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.
NOTE: No Sql Server Software will be installed on client machines.
In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?
Please, somebody can help me for the licensing information and also for the database size? the database will be also used for remote access.
Thank you.
Hi there,
We are currently developing a E-Com research site where subscribed members can conduct market research. The web site is developed and ready to go, however we are undecided what is required on the Database side and could do with some of your expert help.
Users will be conducting research on our MS SQL database. The database holds every product sale made by a select number of consumer good companies. The database holds 12 million records at any one time, however overall the database is very static and is not updated online. We intend to only store 1 months data, therefore on a weekly basis we delete old & add new records.
We are offering three categories of searches on the DB.
1. By Seller
2. By Category (i.e. Hair Care, Laundry etc)
3. By Sale.
The first two searches are not performance intensive as they are compiled and stored in the database - therefore no need for calculation online. Our main concern is the 3rd report. This report is where we allow the user to search for a specified search string. Therefore in the main table that holds all the sales, we have a full-text index for the field "Product Description".
What we are unclear on is the Capacity requirements regarding providing such functionality. I.e What server do we require?
We have researched many articles and have absorbed all the information regarding multiple disk controllers, lots of memory etc.. etc.. However we still have not been able to obtain an idea on what Server would serve our purposes. For example: would the following server do the job?
2 x 2.4Ghz Hyper-threading Xeon CPUs with 512Kb Cache and 400MHz System Bus
2GB Samsung RAMBUS 800-45 Memory (RIMMS / RDRAM)
A lot is determined by the usage, i.e. how many queries are executed per minute etc. At present we do not have a clear idea on the number of users. However we are not truely concerned about this as the 3rd report needs to execute and return within a short period of time. That is our main concern.
Therefore our question is as follows: If you were going to host a database that consisted of 12 million records & full-text indexing which had to be queried in a few seconds, what would you purchase?
We ask you to consider that funds are extremely tight and although the new latest server may do the job, it is most likely out of our budget. We are looking for the most cost effective solution but still statisfying the purpose.
Kind regards
Angus
Hello,
I have been working on SQL Server Capacity Planning for a few weeks now and have gathered a lot of materials, but non of thes materials contain recommended best practices on SQL Server capacity planning and also they do not contain operational guidelines.
I would be glad if anyone can recommend a website or book that contain information on SQL Server Capacity Planning Best Practices.
Thanks,
Jide
I want to know how it calculates CPU utilization percentage (we see in Task Manager).
Further how can we find total capacity of our CPU in ms/sec....
Hi all,
We are going to setup a new server,so for that How to Capacity Plan for CPU and Memory ,Hard Disk for a new SQL SERVER Setup.
Is there any specific criteria for capacity planning ?in which base we should do this part.
Thanks
Kumar
I have an existing Access database that I need to transfer over to a more powerful back-end due to the need for larger size capacity. We need to be able to have a backend that can exist up to just about any size due to us scanning in documents by ODBC. With Access I know I was limited to about 4gb size and when split onto my current SQL server I have heard I will be stuck at 10gb? If so can you recommend a better backend, but my question is about the front end. I hear Windows WPF can be linked into SQL server but does this limit the size as well?
View 3 Replies View RelatedMy SQL server disk space is getting close to full capacity which is causing certain reports that we run via the SQL server to time out because I don't think there is enough space on the server.
Any tips on cleaning out a SQL server? Are there any folders that can absolutely be deleted to clear space? I know on a local computer that the %temp% folder can be cleaned out. I know when dealing with servers you do not want to make to many changes because it can cause major problems down the road.
I am in the process of formulating recommendations with respect to the purchase of additional storage for our current SQL 2012 SharePoint (2013) instance. My recommendation is to purchase separate storage (i.e, 15k disks) for the TempDB and Tlogs respectively (two sets of raid 10 disks). Currently, this server is hosting several instances, including SP, using two arrays (one for database and the other for Tlogs).
I am attempting to find information/recommendations on how to go about projecting the amount of storage for each of these while factoring in for growth.
Additional Details:
how to best formulate a reasonable estimate. Our largest content database belongs to IT and is currently ~80GB. That said, this is currently an outlier. The remaining content databases are less than 10GB (most are less than 2-3 GB). However, SharePoint will be used for digital document imaging in addition to, eventually, replacing file shares as our primary document storage medium once we roll it out.
Our current tempDB is ~400MB, but the instance was recently started a few days ago, as we had to failover to our backup server for hardware maintenance. I do not have any historical data on TempDB growth at this time. Also, I don't know how useful this would be given we have not fully deployed yet.