Michael Hoglan


I have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh. If I doule click nothing happens. I can view the Activity Monitor and the processes going.

I am sure it is a permission thing or something along those lines. I can not for the life of me figure it and have spent a couple days on google and these forums. I have tried with the SA, my defined users, and the local windows administrator. Is log viewing not allowed in SQL Server Express

Thanks!

Michael




Re: Cannot View Server Logs

Andrea Montanari


hi Michael,

SSMSE does not provide that feature.. if you like to inspect the SQL Server log files, you can navigate to the \Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG folder and open the ERRORLOG file with Notepad, as it's just plain text..

regards







Re: Cannot View Server Logs

Michael Hoglan

Thanks, good to know I am not crazy.

So does any of the Express additions support logging I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.

Thanks!
Michael





Re: Cannot View Server Logs

Andrea Montanari

hi Michael,

wait a moment ...

SQLExpress logs it's "system" activities to the SQL Server Errolog file(s) as full blown editions do.. just the SSMSE tool does not provide a direct way to view the errorlog file(s)...

>I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.
this is another story... all SQL Server editions use the database's transaction log file(s).. but you can not directly inspect those files as no public API exists... there's a bunch to third party tools like Luminigent's Log Explorer that can perform that task, but you probably looking for another feature as well.. your last sentence implies the use of Profiler, but this tool is not available with the Express edition... you can use SQL Traces, the underlying architecture used by Profiler, but with no graphical tool to examine results/setting options..

regards






Re: Cannot View Server Logs

Michael Hoglan

Wow I did not expect it to be so annoying to just watch incoming queries into the server.

There is nothing like mysqls logging where I can log incoming queries to a file

$1000 to view some logs is alot...

Thanks!
Michael




Re: Cannot View Server Logs

Andrea Montanari

hi Michael,

not directly... but, again, you can start your own trace to capture server's activity..

regards