Database size

Hi, i'm using SQL Server 2005 Express Edition with advance services. Created a small database with 21 tables and 66 simple stored procedures. The database should not take up huge data in a short period of time. However, when i right click and check out the Database Properties, i noticed that the database size has grown to 1700 MB and available space is only about 0.9 MB. But when i locate the respective .mdf and .ldf file file, the file size of mdf is only about 4000KB and ldf file is about 1,650,000 KB.

I understand that SQL Server Express Edition allows up to 4GB of data file for each database created. But i'm puzzled and would like to know what is actually meant by the databse size and available space that i see via Database Properties. It seems worrying. Can anyone guide me? Thx in advance.

It sounds like your database is running in Full Recovery Model, and your transaction log (the ldf file) is growing. If so, you need to periodically back up your transaction log, which will allow it to release space internally. Then you will need to shrink the transaction log file to get the space back externally.

If you are running in Simple Recovery Model, then you may have a problem with an open transaction.

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.
sql

Database 'ReportServer' does not exist

Shouldn't reporting services setup create ReportServer database
automatically?
The setup fails at the very end with this message:
SQL Server failed to execute command for server configuration. The error
was: Database 'ReportServer' does not exist. Check sysdatabases. ...
Thanks,
-StanYes, Reporting Services install should create the ReportServer and
ReportServerTempDB databases, as well as the AdventureWorks2000 sample
database if you specified that feature to be installed. Be sure that you
have permissions to create the database. Also check the Reporting Services
install log, it may have more information about the error you are receiving.
Jonathan Kyle, MCSD
Microsoft WebData Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Stan" <nospam@.yahoo.com>
| Subject: Database 'ReportServer' does not exist
| Date: Thu, 16 Sep 2004 16:24:41 -0400
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OC#5asCnEHA.1236@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 12.148.36.131
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.reportingsvcs:29431
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Shouldn't reporting services setup create ReportServer database
| automatically?
|
| The setup fails at the very end with this message:
|
| SQL Server failed to execute command for server configuration. The error
| was: Database 'ReportServer' does not exist. Check sysdatabases. ...
|
| Thanks,
|
| -Stan
|
|
||||I have seen this error if there is not default directory set for SQL server
to create databases in. You can check this via Enterprise manager go to the
properties on the server node.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonathan Kyle [MSFT]" <jkyle@.online.microsoft.com> wrote in message
news:5Pan3rynEHA.4040@.cpmsftngxa06.phx.gbl...
> Yes, Reporting Services install should create the ReportServer and
> ReportServerTempDB databases, as well as the AdventureWorks2000 sample
> database if you specified that feature to be installed. Be sure that you
> have permissions to create the database. Also check the Reporting
Services
> install log, it may have more information about the error you are
receiving.
> Jonathan Kyle, MCSD
> Microsoft WebData Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> | From: "Stan" <nospam@.yahoo.com>
> | Subject: Database 'ReportServer' does not exist
> | Date: Thu, 16 Sep 2004 16:24:41 -0400
> | Lines: 13
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <OC#5asCnEHA.1236@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 12.148.36.131
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl
microsoft.public.sqlserver.reportingsvcs:29431
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Shouldn't reporting services setup create ReportServer database
> | automatically?
> |
> | The setup fails at the very end with this message:
> |
> | SQL Server failed to execute command for server configuration. The
error
> | was: Database 'ReportServer' does not exist. Check sysdatabases. ...
> |
> | Thanks,
> |
> | -Stan
> |
> |
> |
>|||Yes, I ran out of space on SQL Server C: driver and setup failed to create a
reporting database
Thanks!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%233TUfQ3nEHA.592@.TK2MSFTNGP11.phx.gbl...
> I have seen this error if there is not default directory set for SQL
server
> to create databases in. You can check this via Enterprise manager go to
the
> properties on the server node.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jonathan Kyle [MSFT]" <jkyle@.online.microsoft.com> wrote in message
> news:5Pan3rynEHA.4040@.cpmsftngxa06.phx.gbl...
> > Yes, Reporting Services install should create the ReportServer and
> > ReportServerTempDB databases, as well as the AdventureWorks2000 sample
> > database if you specified that feature to be installed. Be sure that
you
> > have permissions to create the database. Also check the Reporting
> Services
> > install log, it may have more information about the error you are
> receiving.
> >
> > Jonathan Kyle, MCSD
> > Microsoft WebData Support Engineer
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > --
> > | From: "Stan" <nospam@.yahoo.com>
> > | Subject: Database 'ReportServer' does not exist
> > | Date: Thu, 16 Sep 2004 16:24:41 -0400
> > | Lines: 13
> > | X-Priority: 3
> > | X-MSMail-Priority: Normal
> > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> > | Message-ID: <OC#5asCnEHA.1236@.TK2MSFTNGP09.phx.gbl>
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: 12.148.36.131
> > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> > | Xref: cpmsftngxa06.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:29431
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | Shouldn't reporting services setup create ReportServer database
> > | automatically?
> > |
> > | The setup fails at the very end with this message:
> > |
> > | SQL Server failed to execute command for server configuration. The
> error
> > | was: Database 'ReportServer' does not exist. Check sysdatabases. ...
> > |
> > | Thanks,
> > |
> > | -Stan
> > |
> > |
> > |
> >
>

Database problems

I have an SBS 2003 Premium server. There is an SQL and a Universe database
on this server. Every morning the database services seem to hang. When I try
and manually restart them, I get the following error message.
An error 1053 (The service did not respond to the start or control request
in a timely fashion.) occurred while performing this service operation on
the SQLServerAgent service.
Also the Universe Resource Service - same error.
If I reboot the server, everything is fine.
How can I resolve this problem?Hi,
Check the Memory usage during this situation. If the memory is fully
occupaid then ,Can you make the memory parameter static for SQL Server. I
feel that this is due to resource contension.
Thanks
Hari
MCDBA
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
> I have an SBS 2003 Premium server. There is an SQL and a Universe database
> on this server. Every morning the database services seem to hang. When I
try
> and manually restart them, I get the following error message.
> An error 1053 (The service did not respond to the start or control request
> in a timely fashion.) occurred while performing this service operation on
> the SQLServerAgent service.
> Also the Universe Resource Service - same error.
> If I reboot the server, everything is fine.
> How can I resolve this problem?
>|||I am not sure exactly when it falls over. It is sometime in the night. There
do not seem to be any errors that correspond in the event log.
We are running backups and virus scans in the evening. With backups disabled
problem still occurs.
I have 1.5G RAM in this machine. I can capture memory usage to a log file
through Performance Monitor tonight. How would I make the memory parameter
for the SQL static?
Is it possible that the Universe and SQL are affected by the same problem?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Check the Memory usage during this situation. If the memory is fully
> occupaid then ,Can you make the memory parameter static for SQL Server. I
> feel that this is due to resource contension.
> Thanks
> Hari
> MCDBA
>
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
> > I have an SBS 2003 Premium server. There is an SQL and a Universe
database
> > on this server. Every morning the database services seem to hang. When I
> try
> > and manually restart them, I get the following error message.
> >
> > An error 1053 (The service did not respond to the start or control
request
> > in a timely fashion.) occurred while performing this service operation
on
> > the SQLServerAgent service.
> >
> > Also the Universe Resource Service - same error.
> >
> > If I reboot the server, everything is fine.
> >
> > How can I resolve this problem?
> >
> >
>|||Couple of Ideas...
1. Run a performance logger on the server to see what
resources are low.
2. Put a trace on SQL Server to see when it stops
3. Check the server logs and see if they have errors
4. If you can manage it get some down time on your server
then execute each job separately till you find the one
that causes the error.
To configure the memory
1. Go to EA
2. Right click on your server
3. Select 'properties'
4. Select memory
5. The rest you can guess ;)
Personally I think Hari is correct, it is memory
J
>--Original Message--
>I am not sure exactly when it falls over. It is sometime
in the night. There
>do not seem to be any errors that correspond in the event
log.
>We are running backups and virus scans in the evening.
With backups disabled
>problem still occurs.
>I have 1.5G RAM in this machine. I can capture memory
usage to a log file
>through Performance Monitor tonight. How would I make the
memory parameter
>for the SQL static?
>Is it possible that the Universe and SQL are affected by
the same problem?
>
>"Hari" <hari_prasad_k@.hotmail.com> wrote in message
>news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Check the Memory usage during this situation. If the
memory is fully
>> occupaid then ,Can you make the memory parameter static
for SQL Server. I
>> feel that this is due to resource contension.
>> Thanks
>> Hari
>> MCDBA
>>
>> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
>> news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
>> > I have an SBS 2003 Premium server. There is an SQL
and a Universe
>database
>> > on this server. Every morning the database services
seem to hang. When I
>> try
>> > and manually restart them, I get the following error
message.
>> >
>> > An error 1053 (The service did not respond to the
start or control
>request
>> > in a timely fashion.) occurred while performing this
service operation
>on
>> > the SQLServerAgent service.
>> >
>> > Also the Universe Resource Service - same error.
>> >
>> > If I reboot the server, everything is fine.
>> >
>> > How can I resolve this problem?
>> >
>> >
>>
>
>.
>

Database problems

I have an SBS 2003 Premium server. There is an SQL and a Universe database
on this server. Every morning the database services seem to hang. When I try
and manually restart them, I get the following error message.
An error 1053 (The service did not respond to the start or control request
in a timely fashion.) occurred while performing this service operation on
the SQLServerAgent service.
Also the Universe Resource Service - same error.
If I reboot the server, everything is fine.
How can I resolve this problem?
Hi,
Check the Memory usage during this situation. If the memory is fully
occupaid then ,Can you make the memory parameter static for SQL Server. I
feel that this is due to resource contension.
Thanks
Hari
MCDBA
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
> I have an SBS 2003 Premium server. There is an SQL and a Universe database
> on this server. Every morning the database services seem to hang. When I
try
> and manually restart them, I get the following error message.
> An error 1053 (The service did not respond to the start or control request
> in a timely fashion.) occurred while performing this service operation on
> the SQLServerAgent service.
> Also the Universe Resource Service - same error.
> If I reboot the server, everything is fine.
> How can I resolve this problem?
>
|||I am not sure exactly when it falls over. It is sometime in the night. There
do not seem to be any errors that correspond in the event log.
We are running backups and virus scans in the evening. With backups disabled
problem still occurs.
I have 1.5G RAM in this machine. I can capture memory usage to a log file
through Performance Monitor tonight. How would I make the memory parameter
for the SQL static?
Is it possible that the Universe and SQL are affected by the same problem?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> Check the Memory usage during this situation. If the memory is fully
> occupaid then ,Can you make the memory parameter static for SQL Server. I
> feel that this is due to resource contension.
> Thanks
> Hari
> MCDBA
>
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
database[vbcol=seagreen]
> try
request[vbcol=seagreen]
on
>
|||Couple of Ideas...
1. Run a performance logger on the server to see what
resources are low.
2. Put a trace on SQL Server to see when it stops
3. Check the server logs and see if they have errors
4. If you can manage it get some down time on your server
then execute each job separately till you find the one
that causes the error.
To configure the memory
1. Go to EA
2. Right click on your server
3. Select 'properties'
4. Select memory
5. The rest you can guess ;)
Personally I think Hari is correct, it is memory
J

>--Original Message--
>I am not sure exactly when it falls over. It is sometime
in the night. There
>do not seem to be any errors that correspond in the event
log.
>We are running backups and virus scans in the evening.
With backups disabled
>problem still occurs.
>I have 1.5G RAM in this machine. I can capture memory
usage to a log file
>through Performance Monitor tonight. How would I make the
memory parameter
>for the SQL static?
>Is it possible that the Universe and SQL are affected by
the same problem?[vbcol=seagreen]
>
>"Hari" <hari_prasad_k@.hotmail.com> wrote in message
>news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...
memory is fully[vbcol=seagreen]
for SQL Server. I[vbcol=seagreen]
and a Universe[vbcol=seagreen]
>database
seem to hang. When I[vbcol=seagreen]
message.[vbcol=seagreen]
start or control[vbcol=seagreen]
>request
service operation
>on
>
>.
>

Database problems

I have an SBS 2003 Premium server. There is an SQL and a Universe database
on this server. Every morning the database services seem to hang. When I try
and manually restart them, I get the following error message.
An error 1053 (The service did not respond to the start or control request
in a timely fashion.) occurred while performing this service operation on
the SQLServerAgent service.
Also the Universe Resource Service - same error.
If I reboot the server, everything is fine.
How can I resolve this problem?Hi,
Check the Memory usage during this situation. If the memory is fully
occupaid then ,Can you make the memory parameter static for SQL Server. I
feel that this is due to resource contension.
Thanks
Hari
MCDBA
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
> I have an SBS 2003 Premium server. There is an SQL and a Universe database
> on this server. Every morning the database services seem to hang. When I
try
> and manually restart them, I get the following error message.
> An error 1053 (The service did not respond to the start or control request
> in a timely fashion.) occurred while performing this service operation on
> the SQLServerAgent service.
> Also the Universe Resource Service - same error.
> If I reboot the server, everything is fine.
> How can I resolve this problem?
>|||I am not sure exactly when it falls over. It is sometime in the night. There
do not seem to be any errors that correspond in the event log.
We are running backups and virus scans in the evening. With backups disabled
problem still occurs.
I have 1.5G RAM in this machine. I can capture memory usage to a log file
through Performance Monitor tonight. How would I make the memory parameter
for the SQL static?
Is it possible that the Universe and SQL are affected by the same problem?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Check the Memory usage during this situation. If the memory is fully
> occupaid then ,Can you make the memory parameter static for SQL Server. I
> feel that this is due to resource contension.
> Thanks
> Hari
> MCDBA
>
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:c6la2k$1lue$1@.newsreader02.ops.uunet.co.za...
database[vbcol=seagreen]
> try
request[vbcol=seagreen]
on[vbcol=seagreen]
>|||Couple of Ideas...
1. Run a performance logger on the server to see what
resources are low.
2. Put a trace on SQL Server to see when it stops
3. Check the server logs and see if they have errors
4. If you can manage it get some down time on your server
then execute each job separately till you find the one
that causes the error.
To configure the memory
1. Go to EA
2. Right click on your server
3. Select 'properties'
4. Select memory
5. The rest you can guess ;)
Personally I think Hari is correct, it is memory
J

>--Original Message--
>I am not sure exactly when it falls over. It is sometime
in the night. There
>do not seem to be any errors that correspond in the event
log.
>We are running backups and virus scans in the evening.
With backups disabled
>problem still occurs.
>I have 1.5G RAM in this machine. I can capture memory
usage to a log file
>through Performance Monitor tonight. How would I make the
memory parameter
>for the SQL static?
>Is it possible that the Universe and SQL are affected by
the same problem?
>
>"Hari" <hari_prasad_k@.hotmail.com> wrote in message
>news:OwSaA6DLEHA.1416@.TK2MSFTNGP09.phx.gbl...
memory is fully[vbcol=seagreen]
for SQL Server. I[vbcol=seagreen]
and a Universe[vbcol=seagreen]
>database
seem to hang. When I[vbcol=seagreen]
message.[vbcol=seagreen]
start or control[vbcol=seagreen]
>request
service operation[vbcol=seagreen]
>on
>
>.
>