• SQL Server 2005: Improving performance of Multiple Databases & LUNS

    I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as they are...

    Bulldog9815 pointsBadges:
  • Conducting a performancee baseline comparison

    I was reading this 2-part article on performance baselines. I would like to know how someone actually performs the comparison between the performance on the system with the baseline? How do you use SQL Server Profiler and PerfMon to do the comparison?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Moving Distribution database from an instance to antother does increase performance ?

    The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some...

    AGiachetti5 pointsBadges:
  • SQL Server memory usage

    I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

    Cgardel30 pointsBadges:
  • SQL Server 2005 Performance optimiztion

    I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files....

    ITKE346,285 pointsBadges:
  • Reducing SQL Server backup and restore time

    Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried "piecemeal" restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is having the auto create statistics on in a database a good thing?

    Hello I have a 250GB database and the auto create statistics is on is that a good thing?

    Rick Martinez585 pointsBadges:
  • Resource usage of SQL Server 2005 Generate Script

    Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

    Db23290 pointsBadges:
  • System hangout

    I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem

    Udaykirak15 pointsBadges:
  • Running a lengthy query on SQL Server 2005

    We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tuning and viewing SQL Server reports

    I have developed several reports and deployed on the remote server. While running reports on a browser, it takes about 20 to 30 seconds, but when i browse the same on the remote server, reports get displayed in 5-8 seconds. Do I need to tune my server to enhance its performance, and how should I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Increasing SQL Server performance by excluding files from anti-virus scanning

    To increase our SQL Server’s performance, we would like to take these certain steps: 1. Exclude the anti-virus software from scanning .mdf, .ldf, .ndf, .dtsx, .sql and .msc files. 2. Turn off I/O scanning for the writing to disk and reading from disk processes. 3. Disable buffer overflow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding SQL perfrmon counters

    Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I - read my IT-Trenches blog

    Labnuke9932,960 pointsBadges:
  • SQL 2000 db transactions/sec

    What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

    Labnuke9932,960 pointsBadges:
  • Slowdown in SQL Restore on SQL Server 2000

    We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. I'm sure we could run the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 performance issues

    Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database...

    Labnuke9932,960 pointsBadges:
  • SQL Server 2005 Text Function

    Hello I have used text-function of SQL server 2005. I have ran my codes on a table with 800,000 records to serach for some specific words ( a list of 3milion words) in that. it took about 4 hours to be executed. Now I have some part of that table ( 1/8 of that including 100,000 records). I am...

    Monadba5 pointsBadges:
  • Performance of very large SQL Server table with millions of rows

    Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

    Elhajjh5 pointsBadges:
  • Why and how to performance tune SQL Server 2005

    Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better - SQL Server 2000 or SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sqldumper

    is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it

    Shortfuse455 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following