.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Previous Day - High Level Reporting Usage Summary

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
Want to provide a subscription to send to management the High Level Reporting Usage Summary report. Want to always send previous day's data Monday thru Friday. How can I set that up?


View Complete Post


More Related Resource Links

.NET Profiling: Write Profilers With Ease Using High-Level Wrapper Classes

  

Here Joachim H. Fröhlich and Reinhard Wolfinger show you how to get all the great functionality of the .NET Profiling API the easy way, with custom wrappers.

Joachim H. Fröhlich and Reinhard Wolfinger

MSDN Magazine April 2006


Site Collection Usage Summary: No Data Available

  

Usage analysis processing is enable for my farm in both Central Administration and in the SSP.

I've checked TImer Job Status and the three timer jobs responsible for doing the log analsis are all running.

I've also checked the log file locations and the log files are being generated.

Yet when I browse the "Site collection usage summary" report (SpUsageSite.aspx) I get the following:

No data is available for this report. Usage analysis might have been enabled only recently, or there might have been insufficient usage to result in any values for the report.

My farm is running 2007 Enterprise SP2 (12.0.0.6421).

Can someone confirm if this issue was fixed with one of the CU's that were issues post-SP2?


Can someone give me a high-level overview of DD? What else does it do besides scaffolding?

  
Hello,Having spent the past couple of weeks looking into DD, I'm impressed with the ease and speed with which you can get a CRUD web site up and running.However, I've come across a few things in the last day or so that make me think I'm missing a major part of DD. I've seen hints of much, much more in there. For example, some of the posts on Stephen Naughton's blog mention all sorts of things that look really clever, but are a bit past my understanding of DD at the moment. This makes me feel there's a lot more in there that I have realised.So, can anyone give me an overview of the full picture of what DD offers? Is there more to it than just scaffolding?Thanks

Problem while configuring SharePoint Usage Reporting

  
Hello all.    I was given an already developed MOSS 2007 (Standard) web application, up and running, and I was requested to activate the usage reporting services. So, I did a little search and found the following article that explains just how to do what I want:  http://technet.microsoft.com/en-us/library/cc262541(office.12).aspx As I go through the article, I come across this step on the "Enable usage reporting" section:  "On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting." So, now I notice that I don't have a Shared Service Provider and I can't go on with the aforementioned article. Alright, I did a little search and found this article:  http://technet.microsoft.com/en-us/library/cc262649(office.12).aspx Which would guide me through creating a SSP. No problemo. I follow the steps until I reach the 19th: "In the Index Server section, in Index Server, click the server on which you configured the Search service". And yet no option is available for me, and rather displays a "there's no index server" messsage. But hold on, the same article reads: "If there is no index server listed in the Index Server section, then no server in your farm has been assigned the index server role. To assign the index server role to a server in

Farm or Web App Level Usage Reports?

  
Hi, I was wondering if any OOTB tools can be used to view/generate usage reports at a level higher than site or site collection?  I found the search queries and search results reports through Central Admin which provide some of this higher level/scoped info I'm looking for, but I'd love to find more (perhaps Farm Usage Summary, Farm Requests, Farm Destination Pages, etc.). thank you

Errors in the high-level relational engine. A connection could not be made to the data source with t

  
When I deploy the cube which is sitting on my PC (local) the following 4 errors come up: Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations.  0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'AdventureWorksDW'.  0 0 Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed.  0 0 Error 4 Errors in the OLAP storage engine: An error occurred while the 'Customer Alternate Key' attribute of the 'Customer' dimension from the 'Analysis Services Tutorial' database was being processed.  0 0

Do predefined reports under Summary tab in sql server 2005 cause high CPU spike ?

  
I am using SQL server 2005 sp2 on windows 64 bit server .When I run predefined reports under summary (F7) tab in sql server 2005 ,I saw during that periode ,there were high CPU spike .I checked in monitoring tool Idera .I saw there is one process ran 30 minutes using Master databse ,it cause high CPU spike .I dont know which reports cause high CPU spike .Is there any way I can find report name or location ? Any one can help me to figure out 1) why this report took 30 minutes to run report ? 2) From where can I find explaination of built in reports under summary tab ? 3)Is it good idea to run predefined reports during production hours? 4)which is the proper way to check daily database statistic ? Thanks !!

sql server high memory usage

  

Hello Guys

just wondering how do you handle similar situation, we had a call from angry client saying they are unable to do anything and things take too long to complete. when i logged in i noticed that sql server taking all memory (6GB) for some reason. interestingly CPU usage is normal.

I know i can run profiler to see what queries are taking such huge memory before it happens but what if it already happened and you want to see whats currently eating all that memory ? thanks for the advise.

sql server is 2008 and our desktop app is C# 2008.


prk

High level question about session providers and company..

  

Can someone give me a breakdown of how SessionIDManager, SessionStateStoreProvider, and MembershipProvider all fit together??

Im trying to implement custom providers to work with a legacy session system that we have..


SQL Server 2008 - High Memory Usage

  

Hi ,

  We are facing problem with the high memory usage with SQL Server 2008. 64 bit , standard edition sp2 . 8 GB RAM , 8 processors .

Memory usage keep on growing ..sometimes it will reach to 7.5 GB also .... and its not coming down ..untill we restart the service...

These are the details of DBCC MEMORYSTATUS :: Please suggest how to overcome this problem

Memory Manager                           KB
---------------------------------------- -----------
VM Reserved                              8484792
VM Committed                             4220368
Locked Pages Allocated                   0
Reserved Memory                          1024
Reserved Memory In Use      &n

High CPU usage when the page loads

  

Hi,

 

I want to improve the performance of my web application. Whenever the page loads, it is taking 70-80% of CPU usage.

I'm using ajax timer controls to update the user controls on my page. Also I placed user controls in the update panels of my page.

How to avoid high CPU usage ?

 

Thanks,

Sailaja

 

 

 


Usage Reporting and Search Query reporting in WSS 3.0

  

Hi Every one,

 

I have a following requirement:

I would need to generate a report/fetch the details of what the users are searching for ---->search query logging 

I would need to fetch the details of the most used content from the site ---Site usage logging.

 

Could you please provide me the solutions how i can proceed in WSS 3.0 

 

 

 

 

 

 


Thanks keshav,Share point Developer

High memory usage by the SSMS.exe and no Running Query

  

Hi i am editing a stored procedure using the SSMS (I have SQL Server 2008 SP1 - Windows 2003 Server Standard). At the begining everything is ok, but around of 3 or 4 minutes of work the ssms is becoming to slow, I open the Task Manager and I see that the process SSMS.exe is using 1.2GB of RAM Memory. I have open just one script (The stored procedure that I'm editing) but the script isnt running only editing. I dont understand that high memory because i'm not retreiving data of any query and im not running any thing on my ssms. Take a look of my task manager http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

SharePoint Usage Reporting Quick Poll Question

  

I've got a very quick poll question for any DBAs out there who utilize SharePoint Usage Reporting.

 

Would you rather view your SP Usage Reports inside SharePoint itself, or have them emailed to you once per day/week/month in a PDF or Office formats?


High CPU usage for ReportingServicesService.exe

  
Hi,

We are using Reporting Services 2008 and we upgraded our Report Server databases from MSRS 2005 in October 2009. We had seven incidents in January where the CPU jumped to 100% and remained there until the server was rebooted or the Report Server was restarted.  In February, we have had seven more incidents where the CPU escalated to >80% but we proactively restarted the Report Server in order to avoid a 100% CPU condition.

Although the CPU spikes start at a time when reports are running, the CPU will remain at 80-100% even after the reports have finished and there is nothing in the "queue" (ReportServer..Event table). The first time (before we had a monitor in place), the 100% CPU condition lasted for 72 hours. Task manager shows that the ReportingServicesService.exe process is the culprit, consuming 99-100% of the CPU.

I have examined the ExecutionLogStorage for the periods when the CPU spikes occur and I have also examined the ReportServerService log files.  However, at this time I have been unable to find a consistent pattern or a single report that would be causing the CPU spike.

We have some good graphs of the incidents and I have examined them looking for patterns.  The spikes don't appear to always happen in the same way.  For instance, sometimes the CPU goes straight to 80% while other tim

High memory usage by the SSMS.exe and no Running Query

  

Hi i am editing a stored procedure using the SSMS (I have SQL Server 2008 SP1 - Windows 2003 Server Standard). At the begining everything is ok, but around of 3 or 4 minutes of work the ssms is becoming to slow, I open the Task Manager and I see that the process SSMS.exe is using 1.2GB of RAM Memory. I have open just one script (The stored procedure that I'm editing) but the script isnt running only editing. I dont understand that high memory because i'm not retreiving data of any query and im not running any thing on my ssms. Take a look of my task manager http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

SQL Server 2000 is getting very slow, memory usage also very high but restarted db service it comes

  

Hi,

I am facing slow down problem in SQL Server 2000. SQL Server is very very slow during that time memory also very high usage but when I restart SQL Service it comes to normal. Please advice, if anyone who has experienced in this type of situation. Appreciate if you help to resolve this problem. Thanks

 

S.Jay

 


Mikha
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend