• 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:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    0 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:
  • 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:
  • Configuring a SQL Server to optimize for best performance

    We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Removing a node from a working SQL Server 2005 cluster

    I have Windows Server 2003 with SQL Server 2005 Standard Edition. We have seven divided instances, with each using only two of the three nodes. However, node one has to be taken out of the cluster; what steps should be taken to insure no significant loss in performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Shortening the generation time for a SQL Server 2000 report

    I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server – where clause

    When I execute query like below select * from A where bb in ('1','2','3') That is very fast. not a problem. But in procedure first, if I make a "B" table with '1','2','3' and join with A table like below, select * from a a , B b where a.xx = b.xx and than it is very slow. Do you know why and how to...

    Overbrain5 pointsBadges:
  • Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?

    What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

    Vht5 pointsBadges:
  • Reducing CPU usage on a SQL Server application

    I have Windows Server 2003 and with SQL Server 2005 installed. I run my timesheet software on that SQL server, but CPU usage reaches 70% to 80% when the program is running on many consoles on the client side. Is there a solution to reduce CPU usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

    I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?

    Ftornoe40 pointsBadges:
  • Slow performance for a SQL query

    I have a SQL query I am running, but it is experiencing significant slowdown. The main table - has over 1 million records and a unique key of cusID. It has a one to many relationship with the other two tables mentioned. The query code is as follows: Select customer.cusID,customer.VisitDate,...

    SQL Server Ask the Experts2,585 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