Error when execute checkDB in DB13

[Former Member]

Dear Experts,

I encounter below error when try to execute Check DB in T-code;DB13

I try go to:

https://technet.microsoft.com/en-us/library/aa226369%28v=sql.80%29.aspx

But I do not really understand how to fix the error. Could you please give me advise?

BR,

Fadzly Iqbal

[Former Member]

Hi Zulfadzly

log in in youy sql management studio and try next:

Run the following DBCC commands to free several SQL Server memory caches.

• DBCC FREESYSTEMCACHE
• DBCC FREESESSIONCACHE
• DBCC FREEPROCCACHE

after this try again the CHECKDB

MSSQLSERVER_802

Best regards

[Former Member]

Hi

extend the pool size

Data Source=PerfSQL02;Initial Catalog=Masked;Integrated Security=True;Max Pool Size=1000

Regards

[Former Member]

Thanks,

i was not know how to increase pool size

[behlau_carlos]

Hello Iqbal,

check via Microsoft Management Studio, the usage of your tempdb

Also make sure, you have disk space, where the tempdb is located.

Find out, what jobs are running at the moment, might be a SQL maintenance tasks or job, if you can't extend the disk space.

Best regards

Carlos Behlau

[Former Member]

Dear Carlos,

Please refer the attachments below;

Could you please tell me how to check which SQL jobs are running at the moment?

BR,

Fadzly Iqbal

[Sriram2009]

Hi

1.  What is the size of physical memory?

2. What is the minimum size of Temp DB? During the DB check process could you check the Temp DB & Transaction log size ?

3. If possible clear the transaction log and then try again in the same.

4. Could you check the MS Sql service package level  as mention in the SAP Note

62988 - Service packs for MS SQL Server

Regards

SS

[behlau_carlos]

Hello Fadzly Iqbal,

check out the build in reports - in point of "Top" (Top Session, etc.):

But as S Sriram posted, have a look into your Temp DB Sizes, if they are fixed.

You are finding this out by the properties of the db:

Also you can check in SQL Management Studio your Maintenance Plans (Management => Maintenance Plans).

If you, as example reorg the index of DBs etc. this "consumes" also the free space of the temp DB.

Best regards

Carlos Behlau

[Former Member]

Dear all,

Please see;

1. Initial Size of tempdb

And I also found that my free physical memory is just 22 MB.

Is this the reason why Check DB fail?

BR,

Fadzly Iqbal

[behlau_carlos]

Hello Fadzly Iqbal,

yes, the RAM is really low for a SAP instance (just 4 GB).

You should extend it and also create a pagefile.

Best regards

Carlos Behlau