Can some one advise on the below query?pls

Thanks and Regards,

Ravichandra.

Apologies, I will post the queries accordingly going forward.

Thanks Pradeep.

You mean,I can leave max worker threads Option to default i.e, 0 in SQLServer 2005.

Is it fine ?

Regards,

Ravichandra.

Thanks, But it would be better to set max worker threads to 288 as per the below link and also default setting for SQLServer2005 is 0.

http://sqlblogcasts.com/blogs/thepremiers/archive/2007/05/17/max-worker-threads-configuration-in-sql-server-2005.aspx

Note: we have...

Thanks Gail Shaw.

It was worked and also I have ensured by running DBCC CHECDB once again.

Now fine.

Regards,

Ravichandra.

Thanks for the reply.

Sorry for my late response.

Have you implimented ever before or if you have any document how to set it? please advise.

Thanks in advance.

Regards,

Ravichandra.

Iam not using any query to generate report.

This is server dashboard report...instance (right click) -> reports-> standard report--> Activity-All blocking transactions, when trying this, Iam facing the error.

Please advise.

Thanks and...

Thanks.

Please provide script or suggest free third party tool or any other solution apart from dashboard and trace flag.

For deadlocks, I want to know which query mainly causing this.

Regards,

Ravichandra.

Thanks Gail.

can you advise me on the below requirement.

I can see daily more deadlock information in SQLSeverLog and I want to report it to my manager that these deadlock issues...

Thanks Carl.

Can you elaborate this please.

Regards,

Ravichandra.

Thanks GailShaw.

Yes, you are right, the table size is 30 GB & indexes size on that table 35 GB.

I have one more doubt.

Why data(.mdf) & Log(.ldf) files sizes will be...

Dear Gianluca Sartori,

Thanks for the reply.

The link which you refered to me is very useful and also it's nice script.

When Iam trying to get the avg_fragmentation_in_percent by using the below...

How fast are they growing? -----> how I can check this pls

Regards,

Ravichandra.

The below are the details:

database_size

-----------------

524441.13 MB

unallocated space

----------------------

96174.97 MB

Reserved

--------------

173558688 KB

Data

--------

111380152 KB

index_size

----------

62152776 KB

unused

------------

25760 KB

Regards,

Ravichandra.

To get space...as we have databases like that 15 databases.

If we shrink the databases, we can get the less time to finish the backups and also aquire some space.

Thanks and...

Thank you all.

Please suggest me any related document on this.

Regards,

Ravichandra.