Viewing 15 posts - 3,511 through 3,525 (of 19,560 total)
Here's an option that can be used. You will need to determine what you want to audit in msdb for the jobs, but this can get you going in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 24, 2014 at 7:30 am
see if this is of any help
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 3:20 pm
BWFC (2/21/2014)
SQLRNNR (2/21/2014)
dingleberryClinker
Klink
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 2:58 pm
I have worked on a few in the range of 8+TB.
I have also supported 4500 Instances with multiple databases each.
I have done very busy OLTP and also some very boring...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 2:37 pm
Yeah, it really looks like it will be the no-fun approach to solving this. New database and migrate the data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 12:30 pm
dingleberry
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 12:11 pm
You are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 11:58 am
You could also take a look at the patient encryption demo script provided in this download
http://www.sqlskills.com/resources/conferences/201203devweek_security.zip
That is a session put on by Bob Beauchemin.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 11:30 am
New Born DBA (2/21/2014)
SQLRNNR (2/21/2014)
Also, are you loading the table as the source or are you loading it via a tsql statement?
Sometimes SSIS likes (ok...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 10:39 am
Here is a tool that should be worth your while.
http://sqlserverlst.codeplex.com/
Lara built the Enterprise Policy Management Framework and has this product out there to do RLS and CLS.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 10:20 am
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.
You'd hope if you're working on instances...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 9:57 am
Try dropping the batch sizes down.
Also, are you loading the table as the source or are you loading it via a tsql statement?
Sometimes SSIS likes (ok a lot of times)...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 9:54 am
jcrawf02 (2/21/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 9:53 am
In your migration package, are you batching the record export/imports to 10,000 or something other than the default (which tries to do the entire table)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 9:50 am
SQL Guy 1 (2/21/2014)
DBA-640728 (2/20/2014)
We are getting this alert because physically the file group is removed but logically it is presented and acting as a orphan file.
Unlike Files,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 21, 2014 at 8:15 am
Viewing 15 posts - 3,511 through 3,525 (of 19,560 total)