April 23, 2007 at 10:11 am
Has anybody encountered the following problem ?
When I tried to expand Managment / SQL Server Logs to check error logs, it actually did not expand it and SSMS is hanging since then. I even cannot close it from right-mouse-click/close.
How can I fix this ? What should I set in order to prevent this in future ?
Thanks
April 23, 2007 at 11:47 am
I've never heard of this one. Go to connect.microsoft.com. You can search for the bug there to see if anyone else has hit it. If not, you can report it.
I just did a search over there and couldn't find anything. I tried "expand log" "open log" "ssms hang"
You may want to try a couple of more searches or post a bug.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2007 at 5:34 am
What's the actual size (mb) of the serverlogs ?
I guess it's pulling it over the network, hence the "not responding"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 24, 2007 at 6:20 am
Does it pull them all over when you expand the file list? I definately see a slow down when I open the error logs themselves, but I've not run into when I open the list (yet, knock wood, turn three times, sacrifice a goat to Murphy).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2007 at 6:37 am
...Does it pull them all over when you expand the file list?...
AFAIK it doesn't.
Only when you open them, it will pull them over .... My guess is this was the case.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 24, 2007 at 10:03 am
In order to answer to a question of what size is error log file is I need to know in what folder it stores error log files - I tried to check all possible folders but it's not anywhere.
After I try to expand SQL Server Logs, after a while it displays a message "Failed to retrieve data for this request. An exception occured while executing a T-SQL statement or batch. A secere error occured on the current command. The results, if any, should be discarded."
Is it possible that SQL Server does not keep error log file at all ? Or is it corrupted ?
Thanks
April 25, 2007 at 2:27 am
Open up Sql server configuration mananget.
Connect to your sqlserver-server.
rightclick your wanted sqlserver service, go to the advanced tab and check the startup propetries. The sqlerrorlogfile is specified with the -e parameter.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2007 at 2:35 pm
Should I connect to SS config manager in my local machine or at actual server machine via RDC ?
Because what I see on my local machine SS conf mgr is completely different from your description.
If that's RDC, unfortunately I don't have access to that server.
April 25, 2007 at 11:56 pm
it's a pitty, but you'll need RDC or so.
this script also gives you the parameters.
exec master..xp_instance_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply