Viewing 15 posts - 12,961 through 12,975 (of 19,560 total)
Based on that information and the test results, I would leave the tempdb log on the same LUN as the data file(s).
There really isn't a hard and fast rule about...
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
August 8, 2010 at 9:59 am
Do i understand this correctly?
You
1. backed up the databases in SQL 2000
2. Detached the databases
3. Upgraded to SQL 2005
4. Are now trying to attach the...
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
August 7, 2010 at 10:54 pm
Is the new LUN completely dedicated to the log file for TEMPDB?
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
August 7, 2010 at 10:46 pm
This LUN that you moved the ldf to, what is the composition of it?
How many spindles are involved in the LUN, and what RAID type is it?
Compare that to the...
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
August 7, 2010 at 9:28 pm
AndrewSQLDBA (8/6/2010)
dbo syscollector_blobs_internal 1 960 952 8 0
dbo sysmail_attachments 18 4080 4064 8 8
dbo sysssispackages 21 9640 9616 24 0
dbo sysjobhistory 1000...
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
August 7, 2010 at 4:18 pm
Here is one more resource you can use to help determine your data space usage.
http://jasonbrimhall.info/2010/05/05/sql-2005-tablespace/
That link has a script to help find the size of the tables and directly translate...
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
August 7, 2010 at 4:15 pm
Have you checked to make sure that the data file is truly using as much space as the size reports?
You have a few reports that show that your space usage...
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
August 7, 2010 at 4: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
August 7, 2010 at 4:04 pm
You can find the step by step instructions in the last few posts on the following thread:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102320
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
August 7, 2010 at 1:57 pm
Interestingly enough sometimes I get really good ideas for solutions from unrelated problems.
I sometimes come across these ideas while helping out in the forums, just browsing blogs, etc. I...
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
August 6, 2010 at 4:49 pm
Data visualization seems to be a business buzz right now. It seems people prefer pretty colors and pictures to make quick decisions.
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
August 6, 2010 at 4:43 pm
I think project rotation or task rotation maybe even responsibility rotation is a good way to keep fresh in the business. It helps to be able to do something...
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
August 6, 2010 at 4:41 pm
GilaMonster (8/6/2010)
CirquedeSQLeil (8/6/2010)
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
August 6, 2010 at 2:50 pm
Alvin Ramard (8/6/2010)
CirquedeSQLeil (8/6/2010)
Brandie Tarvin (8/6/2010)
CirquedeSQLeil (8/6/2010)
Paul White NZ (8/6/2010)
Lynn Pettis (8/6/2010)
I love Smarties, 'cause I am one! 😛You bought Joe Celko's book?
HAHAHAHAHA
Technical Guru (goor-oo, goo-roo)- A person who reads...
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
August 6, 2010 at 11:41 am
The Dixie Flatline (8/6/2010)
CirquedeSQLeil (8/6/2010)
The Dixie Flatline (8/6/2010)
because the end users have decided they can do a better job of it themselves.
and are wrong more often than not
You have 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
August 6, 2010 at 11:29 am
Viewing 15 posts - 12,961 through 12,975 (of 19,560 total)