Viewing 15 posts - 16 through 30 (of 57 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...
Greg Roberts
June 29, 2011 at 6:55 am
TheSQLGuru (6/28/2011)
Greg Roberts
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...
Greg Roberts
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...
Greg Roberts
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.
Greg Roberts
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...
Greg Roberts
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...
Greg Roberts
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...
Greg Roberts
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.
Greg Roberts
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...
Greg Roberts
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...
Greg Roberts
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...
Greg Roberts
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.
Greg Roberts
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...
Greg Roberts
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....
Greg Roberts
June 20, 2011 at 2:56 pm
Viewing 15 posts - 16 through 30 (of 57 total)