<div>
Not sure if it's included in MS SQL Server Express, but have you tried opening the Activity Monitor? It should provide you with some info on who's doing what and what kind of queries are being run at that time.
</div>


Not sure if it's included in MS SQL Server Express, but have you tried opening the Activity Monitor? It should provide you with some info on who's doing what and what kind of queries are being run at that time.

<div>
Sorry for the delay, I don't have a current case to test this on.
</div>


Sorry for the delay, I don't have a current case to test this on.

<div>
To determine if what you have suggested for tracking the usage is correct for my circumstance I need to wait for the problem to reoccur so I can test.
</div>


To determine if what you have suggested for tracking the usage is correct for my circumstance I need to wait for the problem to reoccur so I can test.

<div>
Problem hasn't reoccurred, can't really test it until I do, would you prefer me to close the question?
</div>


Problem hasn't reoccurred, can't really test it until I do, would you prefer me to close the question?

<div>
dear networkn:<br />
<br />
its ok with me, if you need more time take it. am really fine with that, dont worry at all<br />
<br />
Regards
</div>


dear networkn:

its ok with me, if you need more time take it. am really fine with that, dont worry at all

Regards

<div>
Problem has not reoccurred. I will close this question and re-open when I have an instance to test on.
</div>


Problem has not reoccurred. I will close this question and re-open when I have an instance to test on.

<div>
<div class="content wysiwyg-content">
Hi, we have a number of servers that from time sqlservr.exe &nbsp;will start using a lot of cpu. It would be useful to know what it's doing during that time.<br />
<br />
Is there a nice way with sqlexpress to see what's chewing resources?
</div>
</div>


Hi, we have a number of servers that from time sqlservr.exe  will start using a lot of cpu. It would be useful to know what it's doing during that time.

Is there a nice way with sqlexpress to see what's chewing resources?

Easiest way to determine what sqlservr.exe is doing

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.