Viewing 15 posts - 19,516 through 19,530 (of 19,560 total)
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 2:00 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 2:00 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:59 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:53 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:48 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:47 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:46 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many 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
July 8, 2009 at 1:46 pm
We use a similar setup for the explicit purpose of being able to easily move databases and instances from one server to another should the need arise.
I would recommend that...
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
July 7, 2009 at 1:47 pm
I agree with Lynn on the NOLOCK hint. Too many places have mandated the NOLOCK on all Select statements. This is one that should have a proceed with...
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
July 1, 2009 at 4:45 pm
Forgot to add to the post that DB optimization is not found in the filegroup solution alone - but can be a piece of the puzzle. In short, 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
July 1, 2009 at 4:37 pm
Having recently done the same thing (and still in progress)
Here are some useful scripts:
Script 1 - determine LOBs per filegroup
select fg=filegroup_name(a.data_space_id), tbl=object_name(p.object_id), idx=i.name
from sys.allocation_units a
inner join sys.partitions p
on p.partition_id =...
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
July 1, 2009 at 4:35 pm
Why does it concern you? You may have moved all the user database objects out of the Primary filegroup, but that is where the system database objects reside, 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
July 1, 2009 at 4:27 pm
I finally pinned it down.
Thanks to the following articles
http://blogs.msdn.com/duncand/archive/2007/01/27/datadude-and-the-text-filegroup.aspx
I have several of these still in the primary filegroup.
Working on a solution now to get the LOB Columns moved to 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
July 1, 2009 at 2:16 pm
After shrinking the primary filegroup (1 file in it), I have no free space. It is currently sitting at 11583 total size and 11572 Used (the used is still...
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
July 1, 2009 at 1:54 pm
Viewing 15 posts - 19,516 through 19,530 (of 19,560 total)