Viewing 15 posts - 3,046 through 3,060 (of 19,560 total)
I don't use the spaceused report so am unaccustomed to the those issues but that is good to know.
In the case of the second issue, generally a re-index will fix...
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
May 23, 2014 at 12:49 pm
ricardo_chicas (5/23/2014)
SQLRNNR (5/23/2014)
Run the script I have on this page and let us know if it reports tables with large space usehttp://jasonbrimhall.info/2014/03/28/table-space-updated-again/
Thanks you!!!
It was a system table related to service...
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
May 23, 2014 at 12:38 pm
Run the script I have on this page and let us know if it reports tables with large space use
http://jasonbrimhall.info/2014/03/28/table-space-updated-again/
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
May 23, 2014 at 12:31 pm
Couple of things...
Where did you get SP 10? 😉
Have you rebuilt indexes since truncating?
Did you have any blobs in those tables that you reduced 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
May 23, 2014 at 12:02 pm
Based on the errors, it appears you have something/someone trying to trunc the log.
the steps you listed are unnecessary to resolve the issue.
Find what is truncating the log and make...
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
May 23, 2014 at 11:59 am
Raghavendra Mudugal (5/23/2014)
SQLRNNR (5/23/2014)
Temp tables can...
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
May 23, 2014 at 11:25 am
Igor Micev (5/23/2014)
SQLRNNR (5/23/2014)
Temp tables can...
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
May 23, 2014 at 11:09 am
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.
Temp tables can be partitioned. ...
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
May 23, 2014 at 10:54 am
GilaMonster (5/23/2014)
SQLRNNR (5/23/2014)
GilaMonster (5/23/2014)
http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to...
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
May 23, 2014 at 8:30 am
Jeff Moden (5/23/2014)
BWFC (5/23/2014)
Ed Wagner (5/23/2014)
Koen Verbeeck (5/23/2014)
BWFC (5/23/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
May 23, 2014 at 8:03 am
BWFC (5/23/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
May 23, 2014 at 7:56 am
Grant Fritchey (5/23/2014)
Or, if you have to name the tables, I'd go with naming them MyTableStaging or something like that instead of using old...
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
May 23, 2014 at 7:55 am
GilaMonster (5/23/2014)
http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB...
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
May 23, 2014 at 7:53 am
Ed Wagner (5/23/2014)
crookj (5/23/2014)
Ed Wagner (5/23/2014)
BWFC (5/23/2014)
RingRule
Decree
Dictate
PotatoHead
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
May 23, 2014 at 7:50 am
is this just the case when running these backups via maintenance plan?
What happens when running a tsql script backup?
Any chance the recovery model is getting switched to simple and back...
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
May 22, 2014 at 10:10 pm
Viewing 15 posts - 3,046 through 3,060 (of 19,560 total)