Viewing 15 posts - 16 through 30 (of 56 total)
I'm sorry i took an overly defensive tone yesterday, it was one of those very bad days.
1) You still didn't answer my question about upgrading SQL Server version
Yes, we upgraded...
June 29, 2011 at 6:55 am
TheSQLGuru (6/28/2011)
June 28, 2011 at 11:16 am
To tag along with this advice, also be carefull that the table you want to shrink does not have other tables with FK references. You are looking into a...
June 27, 2011 at 2:34 pm
You can also look at the INFORMATION_SCHEMA.TABLES to find all tables in a schema. The challenge is finding all OBJECTS in a schema. (Tables, Procedures, Views, etc.) I've had...
June 27, 2011 at 2:30 pm
We have a call with HP SAN Support tomorrow, I'll update with any new information we get. Thanks everyone.
June 27, 2011 at 2:22 pm
also remember that teaming is not recommended on the dedicated heartbeat to, although if you're using Windows 2008 a dedicated heartbeat is no longer required anyway.
We're not running a Windows...
June 27, 2011 at 2:22 pm
Perry Whittle (6/23/2011)
IIRC MIcrosoft do not support or recommend teamed NICs for iSCSI,
You should be using the Multi Path IO component across multiple...
June 24, 2011 at 6:25 am
Thanks for all of the feedback everyone.
All of the files are on there own LUNs. In most cases RAID 10 was not an option. The files are jsut...
June 23, 2011 at 7:39 am
I have run the queries suggested by Syed Jahanzaib Bin hassan and attached the results as a text file. Some of the columns have been removed for security purposes.
June 21, 2011 at 2:29 pm
I found another issue. A new Junior DBA reset all of my SQL Diagnostic Manager alert thresholds to factory defaults. That doesn't mean there is an issue, bur...
June 21, 2011 at 2:08 pm
456789psw (6/21/2011)
Greg, is it just the file growth that is giving you issue?
That was the big smashed thumb. We have also noticed a degradation in our backup times, even...
June 21, 2011 at 12:41 pm
The SAN is dedicated to this SQL Server. There are no other servers accessing LUNs on the SAN.
As far as SAN config is concerned, I'm a bit in the...
June 21, 2011 at 12:29 pm
I agree about not running SQLIO. Unfortunately the SAN did not arrive until the day before deployment, and the business refused to let us delay to properly configure and test.
June 21, 2011 at 12:22 pm
456789psw (6/20/2011)
what has changed on the new SAN....are you running the same number of spindles.....more hopefully?
Went from 2-node to 3-node cluster
what about cache on the SAN, is set to favor...
June 20, 2011 at 3:49 pm
side by side.
we installed new hardware with a clean os and SQL server install. Restored a previous backup to the server and ran load tests. Everything appeared OK....
June 20, 2011 at 2:56 pm
Viewing 15 posts - 16 through 30 (of 56 total)