Viewing 15 posts - 7,366 through 7,380 (of 19,560 total)
Somebody with permissions is turning it off. Or there is a scheduled job doing it. It is possible that a startup proc is also disabling it explicitly. ...
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
December 29, 2011 at 1:40 pm
If I understand correctly, you saw one level of fragmentation, ran the rebuild and think that the fragmentation is the same?
You have less than 1% fragmentation in the logical and...
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
December 29, 2011 at 10:51 am
Stefan Krzywicki (12/29/2011)
GilaMonster (12/29/2011)
Stefan Krzywicki (12/29/2011)
I don't have room on my machine either.Two words: External harddrive.
Seriously, I've had to do that once or twice.
I can't even get them to buy...
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
December 29, 2011 at 9:55 am
GilaMonster (12/29/2011)
Grant Fritchey (12/29/2011)
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
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
December 29, 2011 at 9:53 am
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
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
December 29, 2011 at 9:04 am
Brandie Tarvin (12/29/2011)
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
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
December 29, 2011 at 8:42 am
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
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
December 29, 2011 at 8:35 am
crookj (12/29/2011)
L' Eomot Inversé (12/29/2011)
Brandie Tarvin (12/29/2011)
SQLRNNR (12/28/2011)
Peter Trast (12/27/2011)
Ray K (12/27/2011)
SQLRNNR (12/27/2011)
simplexGrinell
College
Government (the triplicate post made me think of government paperwork)
Tape
Red
Dawn
Revolution
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
December 29, 2011 at 8:29 am
This will help you find the cause of the growth in tempdb.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
December 29, 2011 at 8:28 am
SQL Kiwi (12/28/2011)
SQLRNNR (12/28/2011)
Badda bing - log backups. People should know this one.
True - but this was a change (in 2005) so for many people the change in behaviour...
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
December 28, 2011 at 11:14 pm
2011 was great and here's to an even better 2012.
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
December 28, 2011 at 10:43 pm
Use the query here to find your failed jobs.
http://sqlserverpedia.com/wiki/SQL_Server_Agent_Job_Query_Samples
To query backups for a database, you can query the backupset (and backup tables) in the msdb database.
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
December 28, 2011 at 10:34 pm
Can you post execution plans for each of the two methods?
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
December 28, 2011 at 10:17 pm
Take a look at this article.
http://msdn.microsoft.com/en-us/library/ms191250.aspx
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
December 28, 2011 at 10:14 pm
Badda bing - log backups. People should know this one.
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
December 28, 2011 at 10:12 pm
Viewing 15 posts - 7,366 through 7,380 (of 19,560 total)