Viewing 15 posts - 631 through 645 (of 956 total)
JM,
Thanks for the script.
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]
December 24, 2008 at 8:29 am
bushidi (12/24/2008)
Say to me more on this subject.Tambwe.
Tambwe,
We are going to need a lot more information to be able to assist with this. What did you do, what was...
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]
December 24, 2008 at 8:27 am
I provided all of the code that I use to monitor both database internal file space and disk drive free space. You can find the links to both sets...
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]
December 24, 2008 at 8:25 am
parth83.rawal (12/24/2008)
In Server Name : abc-smtp.xyz.com
Port Number : 2525
and Basic Authentication :
UserName : test@xyz.com
PassWord: ****
Password: ****
Above is working in case of SMTP Server...
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]
December 24, 2008 at 8:21 am
I rarely ever RDP to one of my servers. I RDP to my work Desktop for almost everything. The only things I need to actually be on a...
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]
December 23, 2008 at 9:25 am
Enable logging on the Maintenance plan job step in SQL Agent and log to a file. Then provide the contents from the log file in this post.
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]
December 23, 2008 at 9:21 am
Look in the Setup Bootstrap folder and locate the summary.txt file for the CU. What is contained in that file?
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]
December 23, 2008 at 9:20 am
It won't be a leak. When a backup is running, query the sys.dm_exec_requests DMV and find the session_id that it is running on. Then query the sys.dm_exec_connections DMV...
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]
December 23, 2008 at 9:18 am
Watch your Error Log for the next few weeks and see if you experience App Domain Unloads due to memory pressure. If you get one or two a day,...
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]
December 23, 2008 at 9:10 am
Just a restart of the SQL Server Service is all that is needed.
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]
December 23, 2008 at 9:08 am
Perry Whittle (12/23/2008)
what ADI posted is not what the OP required
How about some explanation why it's not a way to solve the problem? Searching the plan cache for entries...
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]
December 23, 2008 at 8:43 am
We tend to do a lot of outsourcing that become "strategic partnerships" and are more headache than they are worth in my opinion. I don't have a problem hiring...
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]
December 23, 2008 at 8:38 am
Thanks for the laughs today. Kinda boring in the office, so a little humor is a good thing.
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]
December 23, 2008 at 8:31 am
Paresh Prajapati (12/22/2008)
You can set no of maximum user from configuration.
Well if they don't actually have a problem yet, they will once they follow that advice. The information...
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]
December 23, 2008 at 8:17 am
What Adi posted originally is about as close as you are going to get.
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]
December 23, 2008 at 8:15 am
Viewing 15 posts - 631 through 645 (of 956 total)