Viewing 10 posts - 16 through 26 (of 26 total)
GilaMonster (6/17/2015)
Yup. Extended events run for a full business cycle (usually a year). Use the bucketiser and group on the object_id and database_id, that should reduce the data volumes.
Thank you!
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 18, 2015 at 12:30 am
PearlJammer1 (6/17/2015)
good script..thanks very much 🙂
Please note Gail's comment.
It is absolutely correct, that script may not be the most accurate as your cache can change rapidly.
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 17, 2015 at 5:43 am
GilaMonster (6/17/2015)
JimmyJones (6/17/2015)
This will tell you if a stored procedure in your DB had been run since the last server restart (or freeproccache)
Or other event which removes plans from cache,...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 17, 2015 at 5:22 am
jellybean (6/17/2015)
select @@Version: Microsoft SQL Server 2014 - 12.0.2000.8 (X64)
Feb 20 2014 20:04:26
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600:...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 17, 2015 at 5:03 am
PearlJammer1 (6/16/2015)
I have set up an extended events session to gather sp_statement_starting and _completed.
The...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 17, 2015 at 4:57 am
SOLVED
We were able to replicate the issue:
Turned out one of the DBA guys ran the DBCC PAGE command with the log file ID by accident, and that was causing those...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 17, 2015 at 2:09 am
anoop.mig29 (2/3/2015)
r.szasza (1/30/2015)
Just for a long shot:
Are you absolutely sure that log restores are happening on the secondary server?
Is your 'copy folder' is being populated with new files?
You can check...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
February 4, 2015 at 1:01 am
Hello,
Just for a long shot:
Are you absolutely sure that log restores are happening on the secondary server?
Is your 'copy folder' is being populated with new files?
You can check the log...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
January 30, 2015 at 5:05 am
halifaxdal (11/24/2014)
serg-52 (11/24/2014)
Have you tried to installhttp://www.microsoft.com/en-us/download/details.aspx?id=13255
?
Note MS says it's for 2003R2.
Tried that already and it threw some other pre-req
I've found some interesting thread here:
http://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008
The .CSV file will...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
November 24, 2014 at 7:57 am
Hi,
I had to build a similar solution some time ago.
Maybe it's a little overkill and the real Experts will tell a much easier solution, however here it goes:
I'm using two...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
November 24, 2014 at 5:11 am
Viewing 10 posts - 16 through 26 (of 26 total)