Viewing 15 posts - 17,911 through 17,925 (of 19,560 total)
Jeff Moden (1/23/2010)
Detroit. We have Lions here, too, but they have no teeth. 😉
There's a lot more than just teeth that your lions don't have 😛
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
January 23, 2010 at 11:33 am
There is another scenario that could be causing excessive use of the tempdb.
There is a poorly written runaway sql statement causing heavy tempdb usage.
There is also the possibility of a...
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
January 23, 2010 at 10:47 am
GSquared (1/23/2010)
CirquedeSQLeil (1/22/2010)
GSquared (1/22/2010)
Right-click on the database in Management Studio, and select Reports, then...
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
January 23, 2010 at 10:40 am
now i get to go home
but i get to work tomorrow too - woot
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
January 23, 2010 at 1:23 am
Ha - still going.
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
January 23, 2010 at 12:25 am
Jeff Moden (1/22/2010)
If you could gen and capture an actual execution plan, I'm sure...
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
January 23, 2010 at 12:24 am
sp3 for SQL 2005 and sp1 for 2008. There is currently a drive to try to get sp4 for 2005 and sp2 for 2008.
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
January 23, 2010 at 12:21 am
Jeff Moden (1/22/2010)
CirquedeSQLeil (1/21/2010)
If my Key Fob were several TB, would you still permit it?:-DOnly if you'd give me one of those bad boys. 😛
Excellent, can buy my way through...
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
January 23, 2010 at 12:18 am
Please provide the table structure. It seems like there might be a datatype mismatch between the query and the 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
January 22, 2010 at 10:14 pm
Have you tried appending Print statements at various points of the proc to determine where the proc might be failing?
is the proc returning an error code?
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
January 22, 2010 at 10:08 pm
Holy chihuahua - still working.
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
January 22, 2010 at 10:05 pm
It might be trying to do a sort operation while you do that. What is your clustered index on?
it does seem pretty big - better than it was, but...
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
January 22, 2010 at 8:05 pm
Yes - should have dropped that index from the temp table first
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
January 22, 2010 at 7:30 pm
I also would agree that it looks to be a very efficient method of trending your database growth.
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
January 22, 2010 at 6:12 pm
GSquared (1/22/2010)
Right-click on the database in Management Studio, and select Reports, then select Schema...
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
January 22, 2010 at 6:00 pm
Viewing 15 posts - 17,911 through 17,925 (of 19,560 total)