Database Size

Error reads 'database sized exceeds licence limit of 2048 MB per database"
mean?It means you are using MSDE or Personal Edition. Run the following from
Query Analyzer or using osql
select serverproperty('Edition')
If it returns "Desktop Engine" or "Personal Edition" then this error is to
be expected, they have a 2GB file limit on the data files(s). In order to
support larger database sizzes you would need Standard Edition or partition
your data across multiple databases.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
> database"
> mean?|||It sounds like you're using MSDE which has a 2GB per db limit
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
database"
> mean?sql

Database Size

Error reads 'database sized exceeds licence limit of 2048 MB per database"
mean?
It means you are using MSDE or Personal Edition. Run the following from
Query Analyzer or using osql
select serverproperty('Edition')
If it returns "Desktop Engine" or "Personal Edition" then this error is to
be expected, they have a 2GB file limit on the data files(s). In order to
support larger database sizzes you would need Standard Edition or partition
your data across multiple databases.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
> database"
> mean?
|||It sounds like you're using MSDE which has a 2GB per db limit
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
database"
> mean?

Database Performance Halts

Hi,

I have been running a reporting App on an SQL 2000 server, which reads from one large table (roughly 80 million records which grows at around 2 million records a week).

However, it would seem that when multi-users try to access the App and the one large table is Read from using 1 database user name up to approximately 25 times, the system would slow to a halt. Essentially, each request on the App would be a new connection to the SQL database using the same database user name. Recently, we have been running into performance issues since we have increased the number of users for the App.

What would be causing this slow down? and what could solve this problem?

>>What would be causing this slow down? and what could solve this problem?

Do you have indexes on the table? are the queries sargable? are your statistics up to date?

>>and the one large table is Read

What does this mean how is the table read? Are you just doing a select * from table?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

>>Do you have indexes on the table? are the queries sargable? are your statistics up to date?

I have indexes on the table and seems to work perfectly fine when there is only 1 query running. All the queries I am running are based on atleast 1 index on that table. Also which statistics are you referring to?

>>What does this mean how is the table read? Are you just doing a select * from table?

From what I can tell, it should only be a series of select statements or nested select statements that the report App runs and stores on the report App side. The reporting App is making from 10-30 of these requests on that 1 indexed table at a single moment in time.