Viewing 15 posts - 1,336 through 1,350 (of 6,400 total)
Ed Wagner - Wednesday, November 29, 2017 6:22 AMBloviate
verbose
November 29, 2017 at 6:36 am
Start with internal.operations, then work down.
You know what you need to do now, go check the data, if it is older than 28 days go speak to Microsoft. ...
November 29, 2017 at 6:26 am
If you want to know what is logging, go and query the database.
Go build the ER diagram.
Go query internal.operations, join it to all of its child...
November 29, 2017 at 6:18 am
As I have already said a number of times.
Even with logging set to None, you still have logging. It is very minimal logging, with enough information to see...
November 29, 2017 at 6:15 am
Build the entity relationship diagram from within the SSISDB, find the relationships, and look at the root internal.operations and query the child tables, you don't want to purge anything with...
November 29, 2017 at 6:01 am
If 14GB for your SSISDB is to big reduce your retention period, let it purge, then shrink it. Once shrunk rebuild your indexes.
Even with logging set to None,...
November 29, 2017 at 5:54 am
Even with the logging level set to None you still get logging although it is very minimal logging.
November 29, 2017 at 5:46 am
Do they see processes for the whole server or just their own session?
November 29, 2017 at 3:30 am
This is a Microsoft SQL Server forum, not an Oracle forum. While some people here may have some experience with Oracle, it is not everyone's main subject here, so it...
November 29, 2017 at 3:27 am
Have you confirmed permissions on the mssqlsystemresource files and directory? Ensure NT Service\MSSQLSERVER has full control.
Did you change the service account via services.msc or the SQL Configuration Manager?
November 29, 2017 at 3:20 am
November 29, 2017 at 3:00 am
It is information based on the executions of your packages, start times, end times, durations, any messages, anything from the event handlers, execution statistics. The more packages you have, the...
November 29, 2017 at 1:42 am
What's the question based on that latest picture?
If you feel that 14GB is to big for your data file you will need to reduce the retention period, to...
November 29, 2017 at 1:26 am
Viewing 15 posts - 1,336 through 1,350 (of 6,400 total)