Lavanyasri (8/6/2012)

---

when i try to run the dbcc opentran() on that particular database its showing the below open transaction

Transaction information for database

Oldest active transaction:

...

franck.maton (8/6/2012)

---

@anthony-2.Green

I could, but I've more than 3.600.000 records for today. But it's like:

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.819

2012-08-06 00:05:28.820

What are you thinking of ?

@Cadavre

Yep, i'm working on...

Can you provide the CounterDateTime values

SELECT CounterDateTime

FROM [MSSQL_PerfmonCollector].[dbo].[CounterData]

WHERE CounterDateTime LIKE '2012-08-06%'

Assuming you use ISO formatting, other wise change the like to match...

Its basically created a concatenated string of column names as 1 row instead of multiple rows.

This may also help in understanding the query,

http://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-ms-sql-server-2005

Well something needed that space, if you dont know what then I would recommend tracing the server, but if it only happens once in a blue moon then unless you...

If you have such a big log after 30 minutes, then change it to 15 minutes.

You can shrink the log in full recovery, but you will have to wait until...

I would recommend reading this http://www.sqlservercentral.com/articles/Administration/64582/ before you do anything.

If the log file jumped to that size, it was for a reason and would probably do it again.

As detailed already,...

Do you have any weekend processes like rebuild, reorganise indexes etc?

What is the autogrowth setting of the DB in question?

Do you keep a record of the space used on a...

Full backups do not do anything to the transaction log. Only a transaction log backup can mark the log as re-usable.

How often is the log backup taking place?

duplicate post, and from other posts comments seems like homework.

Have you checked out the Microsoft Learning site?

The only way I can think of off the top of my head if you dont want to use subscriptions, is to build your dynamic proc and format it in...

Drop and recreate the index, would be the quickest solution.

This is standard behavour, the log will become larger than what you are used to as it is not marking the log as re-usable until a log backup occurs.

How often...

Have you checked with your mail administrators that you can actually send to an outside domain?