Hi,

thanks for this link, sounds very good.

😉

Hi,

is the mdf bigger, or the ldf file?

Can you check you scheduler, if there are some maintenance jobs like index-rebuild? Is there some replication, or mirroring?

What is the result of

dbcc...

Hi,

if you use replication, you are able to decide, which table, view or something else should be replicated.

If you use logshipping, the entire database will be synchronized.

Kind regards,

Andreas

reported as SPAM

Hi,

the account who started the sql-server / sql-server-agent, has this account rights to the file/folder, or only to the share?

Kind regards,

Andreas

Hm,

try this please:

USE DISTRIBUTION

GO

SELECT * FROM [distribution].[dbo].[MSrepl_errors] ORDER BY time DESC

Or just search for this object, it must be...

Hi,

take a look in the replication monitor. Are there any error or something like that. Is everything fine, or some red "x"?

And take a look at your error from distribution...

Hi,

maybe this could be interesting:

http://schemaspy.sourceforge.net/

Kind regards,

Andreas

Hi,

if you have no access do SSMS, you can try this command in powershell:

SQLCMD -L

You should get a list of sql-server with instance name.

Hope you've the right to execute.

Kind regards,

Andreas

Hi,

with this query you can select your error from replication

Please run this query on...

Please note: 3 year old thread.

Hi,

could you give us your configuration of your tempDB? If you use only one file for the tempDB, it might by your bottleneck.

Kind regards,

Andreas

Hi,

maybe you can use the profiler to scan your activities on the server in the night.

Or just use the dmv, to identify the queries with the most IO / CPU.

I...

Hi,

just remove the WHERE condition, and watch for your running process. There should something with rebuild, index or?

Or just watch all running process with your SID.

Kind regards,

Andreas

Hi,

maybe this could help, to decide to cancel the maintenance or to wait until it is finished:

SELECT a.database_id,

a.name,

b.command,

b.percent_complete,

b.start_time,

...