<div>
I remember someone told us to have seperate mirroring concept of DB and have reports on that server.. Please advise the right way ..<br />
<br />
Thank you in advance !!
</div>


I remember someone told us to have seperate mirroring concept of DB and have reports on that server.. Please advise the right way ..

Thank you in advance !!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp; &nbsp; &nbsp;Our team is building a customized ERP application with c#,asp.net,mssql 2008 which almost all are postlogin pages. Below are the more details.<br />
<br />
2 servers - 1. Application with webpages and reports , 1.DB server (only database - ms sql 2008)<br />
Total Pages - 200 to 250 .aspx pages<br />
Reports - 75 reports with 10 types of filtering in each report.<br />
Approximate number of users - &nbsp;250 users. But will increase more in future.<br />
Application type - Very critical billing application.<br />
<br />
Our perfomance testing is showing good results. But reports we are yet to test..<br />
<br />
At present we have setup the aspx pages &amp;&nbsp;reports in 1 server and database in another. Is this advisable ? . Reports are used a lot by many users parallely. &nbsp;Should we continue as it is or else have reports in database server seperatly ?.. Please advise !!<br />
<br />
Thanks !!
</div>
</div>


Hi,

     Our team is building a customized ERP application with c#,asp.net,mssql 2008 which almost all are postlogin pages. Below are the more details.

2 servers - 1. Application with webpages and reports , 1.DB server (only database - ms sql 2008)
Total Pages - 200 to 250 .aspx pages
Reports - 75 reports with 10 types of filtering in each report.
Approximate number of users -  250 users. But will increase more in future.
Application type - Very critical billing application.

Our perfomance testing is showing good results. But reports we are yet to test..

At present we have setup the aspx pages & reports in 1 server and database in another. Is this advisable ? . Reports are used a lot by many users parallely.  Should we continue as it is or else have reports in database server seperatly ?.. Please advise !!

Thanks !!

ASP.NET application perfomance

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.