Wednesday, April 17, 2013

[SQL 2012] New Relic - realtime application monitoring software

[SQL 2012] New Relic - realtime application monitoring software


New Relic - realtime application monitoring software

Posted: 17 Apr 2013 03:27 AM PDT

Hi -We're using New Relic to monitor our application along with application servers. The application provides extensive realtime monitoring and it is quite nice.It provides in depth analysis for both applications and application stored procedures.Has anyone in the SQL community actually installed the agent on a production SQL Server?Thanks in advance.

Alway on error

Posted: 17 Apr 2013 01:22 AM PDT

Hi All,I am getting below error in SQL Server errorlog.Timeout occurred while waiting for latch: class 'HADR_BACKUP_LOCK_RESQUEUE_TABLE'.Thanks,Praful

Tabular - aggregate data in the fact table?

Posted: 17 Apr 2013 01:51 AM PDT

HelloI'm currently designing a new tabular model which contains sales data. The sales data is received at a low level hierarchically speaking (Day, Store, SKU). The reports for this dataset however are not required at such a low level. The requirement is to view the data by month, county and product group. Should I aggregate the data in the fact table to month, county and product (using a view or a SQL statement) or should I allow tabular to use the hierarchies in the warehouse to aggregate the data? Any advice would be appreciated.

Do you need Visual Studio for 2012 SSMS?

Posted: 16 Apr 2013 07:10 AM PDT

Everyone on my team has Visual Studio 2010 installed on their computers. We just upgraded from SQL Server 2005 to 2012. I have a couple of other users that only need SQL Server Studio Manager for 2012. The 2005 version they have does not work with our upgrade.Do they need Visual Studio installed in order to use it? That seems like a lot of overhead just to view a table or create a query. But someone is instisting they do. I just wanted to know before I did the install.Thanks.

No comments:

Post a Comment

Search This Blog