Navigation

Search

Categories

On this page

LogParser samples for the Windows Event Log
Message Box Error and Solution
Todays Message Box Error and Solution

Archive

Blogroll

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 120
This Year: 1
This Month: 0
This Week: 0
Comments: 40

Sign In
Pick a theme:

# Monday, January 11, 2010
Monday, January 11, 2010 1:13:42 PM (Mountain Standard Time, UTC-07:00) ( )
One of my buddies asked how to do the following today:
Suggest the size of the Event logs for a Windows 2003 Infrastructure.
I don't know if there's a hard recommendation from the mothership in Redmond, but I have learned that you should figure this out based on your own environment. My mom-and-pop shop may have fewer entries than your fancy multi-site active directory enterprise. So, we should just get some data, and infer what we should do. Maybe doing this once a week for the first month, and then once a month thereafter should suffice.

Microsoft has, for quite some time, produced a log parsing tool known as "Log Parser".  It's current release (as of June 2006) was version 2.2.  It is available as a free download from Microsoft at:  http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en

The queries I used to get the data of interest would be this.

Get the size of the event log per day for the Application Event log
logparser.exe -i:EVT "SELECT TO_DATE(TimeGenerated), SUM(STRLEN(Message)) FROM Application GROUP BY TO_DATE(TimeGenerated) ORDER BY TO_DATE(TimeGenerated)" -rtp:-1

Get the number of events per day for the application Event log
logparser.exe -i:EVT "SELECT TO_DATE(TimeGenerated), Count(*) FROM Application GROUP BY TO_DATE(TimeGenerated) ORDER BY TO_DATE(TimeGenerated)" -rtp:-1

a smart person might put this data into Excel and calculate the average size per entry, and then draw some conclusions.

Make sure that you record your captured data, your predections, and your actuals so you can make better predections in the future.

Comments [0] | | # 
# Wednesday, December 30, 2009
Wednesday, December 30, 2009 2:05:44 PM (Mountain Standard Time, UTC-07:00) ( All things Microsoft )
Here's another error I got today while using Visual Studio 2008

---------------------------
Microsoft Visual Studio
---------------------------
Error connecting to undo manager of source file 'C:\dev\Work\ReportBrowser\ReportBrowserWeb\SiteLayout.Master.designer.cs'.
---------------------------
OK  
---------------------------

Found a good solution here
http://www.hanselman.com/blog/CommentView.aspx?guid=8bc798ae-da26-4864-b4e3-b68b081b4be1

1) Right-click the designer file and select delete
2) Right-click the aspx file and select Convert to Web Application

Comments [0] | | # 
# Wednesday, December 23, 2009
Wednesday, December 23, 2009 12:47:21 PM (Mountain Standard Time, UTC-07:00) ( All things Microsoft )

I've decided to start a new series of articles on how I solve various problems in my daily programmer lifee. Usually a problem has a distinct message box that shows up which you can copy the text of with the CTRL + C key combination. I think that a lot of people search directly for this text, and it woudl be awesome to have it solved. Maybe I'll even start a website some day to host these solutions so that people (or in a perfect world the vendor...) can post a solution to them. For today, here's my problem that I experienced inside of devenv.exe (Visual Studio 2008) today while trying to use the Server Explorer to add a new Data Connection.

---------------------------
Server Explorer
---------------------------
Unable to add data connection.

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
---------------------------
OK  
---------------------------

I was tipped off by this forum post http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.vstudio.general&tid=89ee0e86-b8fc-40a7-a0e1-51ac4033302e&cat=en_US_38f7e3d1-40bd-4daf-941f-f45d2ff6ff9b&lang=en&cr=US&sloc=&p=1

to install the SQL Server 2008 Managment Objects and Native Client, which you can get from here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist

Or more specifically, here

Microsoft SQL Server 2008 Management Objects X86 Package http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409

Microsoft SQL Server 2008 Native Client X86 Package http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

Comments [0] | | #