hi all
i want to know that how much performance of ssrs will be vary when i m installing ssrs on same machine where my database is stored, or when i m storing ssrs on different machine and database on different machine.
Hi,
Whats the best way to test scalability on a database? I'm working on a new app, and have handed off developing the database to someone with more experience. Some tables will grow to many million records, and I don't want it to bottleneck. I need to have it fully tested before it goes live.
Is it reasonable to ask the person helping me to fill it with 10's of millions of rows to test performance? Is this a decent solution? If so, what would the best way to fill it be? If not, what steps should I take?
Thanks very much!
mike123
Could someone out there please help me to answer these questions?Thanks in advance.1. What aspects of SQL Server allow it to reliably scale up to supporta large global enterprise? And, when does SQL Server reliabilitybegin to fail?2. Given a role-based security model and without doing a benchmark,are there potential performance issues of using a SQL Server database ?How would this change if more of the security was moved to theapplication level or moved to the database?3. How does SQL Server manage access to data at the record and datafield level?4. w do support and administration requirements compare between SQLServer (or MSDE) and Oracle? Consider levels of expertise needed fromcentral server to desktop implementations.
View 1 Replies View RelatedHi, I'm looking for some recent surveys on the performance of ETL-Tools including SSIS and relates it to other ETL-vendors. Any ideas where to find valid stuff?
S.
I am trying to find some information on recommended deployments, preferably with a diagram for a presentation.
View 12 Replies View RelatedHello All,
I was just looking for some rough estimates on the number of simultaneous users that SQL7 EE can support in a Web (IIS/ASP) environment. I know there are a lot of configuration issues that will effect the answer, but assume that there are a couple of IIS servers running WLBS that need to connect to the SQL database for query and update functionality. Of course, all access to the database will be controlled through stored procedures. Any thoughts would be most appreciated...
Thanks,
Chris
Our databases were working fine in terms of performance until over the last 2 months wherein the timeouts and deadlocks have started increasing. We are having growing clients with huge real-time transactions. We have been adding NOLOCKs on queries that are being used frequently etc but the timeouts are still an issue. Not sure what the best way to identify problem areas is. The CPU utilization has also been on the higher side. Profiler identified long queries are being indexed etc. But the performance is still a concern. Any ideas? What am i not looking at? HELP HELP..
Thanks,
Sri
I understand mount points help scalability in easier maintenance.
By scalability do we mean more than 26 drive letters or it means adding more space to the same mount point letter on with more ease .
Can I add more space to a mountpoint if required later on by adding hard disks .
Also if one can give some pointers to good file group configuration guidelines / storage align partitions , it will be very much helpful
Further I my server CPU has 4 cores , will having 4 filegroups help me in improving system performance.
If SAN has 2 controllers , is it preferred to run data file partition on one controller and log file partition on another.
Thanks in advance.
We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big.
We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run.
We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany.
Or maybe database partitioning by language???
Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main database and maybe 2 (Spanish and German) €śsatellite€? databases or something like that €“ any ideas???.
Any suggestions of how to deal with this problem the best way would be greatly appreciated. We are using SQL Server 2005.
Newbie!
We are beginning to design a new application with SQL Server 2005. Our current production environment is slated to be two SQL Server 2005 machines with the databases residing on an EMC SAN. We have requirements to both have automatic failover between servers for availability and also be able to balance the load over two hot servers for scalability.
Can anyone point me in the right direction for things I need to consider in order to be able to implement both of these requirements? Can I implement database mirroring (for failover) and transactional replication (for balancing) given the hardware configuration I'v mentioned? Is more information needed? Where should I turn next?
I am coming off a mainly Oracle background for the last ten or so years with a smattering of SQL Server mixed in. I've tried to hit the ground running on this project, but sometimes find myself hitting the wall running instead.
Thanks,
Larry
We have a high load site that requires some redesign. We would like to move the PK generation from a custom scheme to IDENTITY columns.
What are the any scalability issues for using IDENTITY? Will contention issues arise because of row locking?
Thanks in advance.
Hi,First I would like to apologize for cross posting in three groups asI did not know which one would be the appropriate group. If some onepoints me to the correct one I will use that in the future.I am trying to findout the scalabilty of an user written extendedstore procedure. I have created a dll using a C program(modified/plagarized from some of the examples) . The main function ofthis extended SP is to act as a passthru to connect to an third partyODBC driver. All this is supposed to do is take the passthru sqlstatement, userid, passsword and connect to a remote server (IBM 3090Mainframe in our case) using a system ODBC connection and pass thereturned result set back to the stored procedure calling this extendedSP. I am trying to find out the answers for the following questions.1. What are the limitations of this approach.2. What would happen say if 2,000 concurrent calls per minute are madeto the extended SP from the web app.3. What would happen if this continued for say 4 hours. Will the memoryusage increase to point that will cripple the server assuming there isno memory leak in the dll.4. Are there any connection pooling concerns that I should payattention to specifically from an Extended SP point of view.5. Apart from compiling the dll using the "MultiThread" option should Ibe using other options to make sure the dll is threadsafe.SQL server Environment :OS - Windows 2000 Advanced Server SP4SQL - SQLServer 2000 Enterprise edition SP3Hardware - 8 way 2 node cluster with 6Gb RAMAny help regarding this is greately appreciated.Prahalad
View 3 Replies View RelatedHi,
Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?
Thanks,
Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012
My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?
if not what code changes we should do?
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
The developer PC is Windows Vista Business.
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
Thanks!
-ErikR
Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?
I really appreciate your help on this.
Thanks,
Sam
I did a quick Google for this but found nada...
If I develop a report in SSRS 64 bit, can it be ported to a 32 bit installation? Any issues?
I will do my own testing, but I was curious if anyone else had experience doing this.
send me some procedures to test reports in ssrs (sql server 2005)
sunil
Hi,
In a .net application there is a link that brings up a SSRS report.
I have noticed that if it is the first time this report is requested i.e. Application has just been opened and the report button is clicked, then it takes a while to get this report to appear on the screen. But if this report is requested again (i.e. for the second time or more) then it only takes a few moments for the report to appear on the screen.
So it seems that only the first time the report is requested it takes a longer time to get this report. Is there a way to reduce this initial load of the report?
Thanks
Can anybody give share with me how to establish the basic connection between SQL Reporting Services and Great Plains 9.0? They are on two separate servers if that makes a difference.
Dennis.e.graham@hotmail.com
Hi. We currently have about a 100 Crystal Reports with embedded images and text in the *.rpt files. If we were to switch to SSRS 2005,
Can we do a global search-and-replace of images and text within the SSRS reports? We have some letterheads that have names of people who might change every year or two.
Are there any tools to convert Crystal Reports *.rpt files to SSRS reports? These 100 reports would be time-consuming trying to convert to SSRS.
Thank you much
Alex
Hi Guys
I have an ancient app that produces a pipe delimited file for the printing of certain invoices (which i can present in reporting services). I am able to fire a batch file or script from this able and pass the name of the file through to the script...
My question is: is it possible to have the stored procedure fire a DTS pkg to "massage the data" before running the report?
Has anyone had any experience doing this or other ideas i could try. i'm using SQL2k
TIA Stephen
hi guys,
In ssrs i have two rows, The two row i have to design in to vertical, how to do?
anybody plz help me
I had a potential client ask if SSRS would work with a vpn connection if someone is off site. Does anyone know if this will work?
Thanks,
Ryan
Hi,
I want to get five tables of a report to be repeated on different sheets of excel based on a variable.
Thanks in Advance.
Nalini
I have a stored procedure wihich returns the table like
class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
022 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120
041 $120 $110 $100 $80 $150 $120
006 $120 $110 $100 $80 $150 $120
002 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120
i want to display a report in SSRS in two groups 1st group (001, 021, 003, 005) there is no 022 in this table where in another group (006,036) there is no 002. it should display as follow with the total of sales
class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120
total 480 440 400 320 600 480
class sunday monday tuesday thursday friday saturday
006 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120
total 240 220 200 160 300 240
in the Dataset of SSRS i can see only class, sunday,monday,tuesday,wednesday,thursday,friday,saturday.
plzzzzz help me how it is possible in SSRS or any other sujjestion. it will be appreciated... Thank u all in advance...
hi
we bought ss2000 std ed in 2003.
how can i get ssrs 2000? is it a free download?
thanks
evan
Hello
I am going to Intsall SSRS on Cluster load balanced web servers. Shall i install SSRS on both nodes? When i go to msdn, the caption as:
"You must use other products to support access through a virtual server and cluster deployment. Reporting Services does not provide load balancing functionality or virtual server features that allow you to access all report server instances through a shared URL address."
I have my vip and virtual url ready for installation. how can i install SSRS in high availability? please advice. Thanks.
Hi All,
I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.
Thank's in advance..
Hello everybody,
I'm new to SQL,I have a interview tomor,so please i need a website from where i can get questions related to SSIS & SSRS.Please help me.
Thanks in advance
How it is possible to Run (2 or 3)Reports(SSRS) From SSIS With Default Parameters ? Please Help Me Out
Praveen John
Software Engg
Regards
Praveen John
+91-9895074288
"Frankly, my dear, I don’t give a damn"
I'm trying to set up the Report Manager Virtual Directory. But the little X just wont turn into a tick - even though I click New, then OK, then Apply.
Has anyone else had this problem?
I've managed to get SSRS running before but for the life of me I can't get it going! So annoying! Does anyone have a link to a simple Walkthrough or something for getting SSRS of the ground so that when you navigate to http://localhost/reportserver, you don't get "The Page can not be found".
Hi All,
I have a project in MS Acces, I have to do the entire project in .Net.. The same MS Access Project has a lot of reports and For these reports I have to use SSRS..So, I need to know about importing the Access reports to SSRS.. Is this advisable to import the reports from MS Acces to SSRS or to create new reports in SSRS..If I import the MS Access reports to the SSRS ..can I use them as the same as that of the newly created reports in SSRS.. As I imported all the reports but failed to understand how the query is written...and how the data is drawn from the datasource...As I dont have nay data in my SQL Server 2005.. How the reports are showing the data..in SSRS when they are imported from ACCESS..as my SQL Server has no data in it...Please help me it is very urgent..I am new to the reporting ..so need more information where I can Learn more..
My Maijn question is that is this Advisable...to import the Reports from MS ACCESS to SSRS or build the new reports..If imported what are the measures I have to take...to look and feel the reports as that are made freshly in SSRS...The reports are really big ones in MS ACCESS.. Replies needed ASAP..
Thanks
dotnetdev1...