Viewing 10 posts - 16 through 25 (of 25 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!
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.
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,...
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:...
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...
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...
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...
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...
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...
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...
November 24, 2014 at 5:11 am
Viewing 10 posts - 16 through 25 (of 25 total)