Viewing 15 posts - 556 through 570 (of 956 total)
Sir Slicendice (1/8/2009)
But depending on the workload, the...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 9:03 am
The hostname as previously suggested would be the only way I can think of to come up with this without changing your app code to track the users information in...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 7:53 am
Look in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG folder and post the summary.txt file that is located there.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 7:49 am
Can you export the deadlock graph to XML and post that here?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 7:47 am
Conan Whalen-McKain (1/8/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 7:38 am
henrik staun poulsen (1/8/2009)
How do you tell the difference between mediocre and great Admin?
We have two people working with the SANs, but are they any good???
I would like...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2009 at 7:11 am
Paresh,
The default trace won't affect the verbosity of the logging that SQL Server does to the Windows Event Logs.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 9:59 pm
One thing that I just thought of that you didn't mention in your article is that you can also use your redundant paths to the SAN to balance your IO...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 9:43 pm
Good job covering an important topic when it comes to good configuration of your hardware layer for a solid ESX implementation.
Now prepare for the flame war over Virtual vs Physical...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 9:32 pm
Triggers are always the last place we tend to look for problems which is why their use should be documented and scrutinized before actually going into place.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 8:16 pm
A full version of Visual Studio? I didn't catch that it was the Visual C# 2008. I am assuming Express Edition? I am not sure about the...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 7:05 pm
noeld (1/7/2009)
make them part of SQLAgentReaderRole
You also would need to remove them from the existing role that is providing them the rights currently. Don't forget to add the login...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 6:23 pm
The only thing you could do is as you've already found, use the -n startup problem, but as you also state, the trade off is that you don't get any...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 6:20 pm
What is the time period that you are looking at in Profiler with the perf data loaded? If you restrict the Perfmon graph to the same period of time...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 6:16 pm
Something happened to your reply. All I see is a quote of my post.
EDIT:
Nevermind I see it now. I understand what you were after now.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 6:11 pm
Viewing 15 posts - 556 through 570 (of 956 total)