We're importing data into Microsoft CRM via the webservice API provided on a huge installation. The numbers are 1.3 mio accounts and 1.0 million contacts.
CRM is in fact "just" a web service hosted on IIS which makes some SQL statements.
The SQL server is a 64-bit 8-way machine with 16GB of RAM and it is only hosting the two CRM databases (data and metadata). The problem is that no matter how many IIS Worker processes or http connections we make SQL will only use two CPUs. How can we leverage on all the ressources we got? Is there some kind of internal Connection Pool that we have overlooked?
I've read the MS CRM Performance Tuning Paper but it doesn't say much about SQL so thats why I'm posting in this forum
i use to run the stored procedure as a task daily, but since yesterday i am getting the error my tempdb is full ,and that process is stopping. does anybody know solution for this problem thanks in advance
I have an Integration Services project which creates a flat file report from Analysis Services, I'm using an OLE DB as data source and running an Openquery in the SQL statement.
the problem is that Integration services runs the query twice before getting the data into the flat file. I know this because the query runs two times in Profiler, and because the same query takes half the time when run in Management Studio.
Integration Services is running the whole query when validating. how can I disable this validation or better make it validate properly.
I am getting following error when query using a full-text index:
select * from workitemlongtexts where Contains(words, 'test');
==error message== Msg 7619, Level 16, State 1, Line 1 The execution of a full-text query failed. "Service is not running."
I have verified that 1. msftesql service is running, 2. I even rebuilt the full-text index and it didn't help 3. my full-text crawl job is running fine 4. my DB is full-text enabled
Can someone explain what "Service" the error refers to? I am using SQL 2005 Ent SP1.
I have sql server 2000. I copied a database from one server to another. I have one table that has a full-text index. When I transferred over the database, the index still existed, but was not populated. I made sure the path for the file is pointing to a new correct location. I did "start full population". It only populated one entry @ 1MB. On the old server the index is 100MB with more than 3 million records.
I tried rebuilding, re-creating, and it all works, but when I run "start full population", it only populates 1 record. I double checked the table in question and it has over 3 million records and proper primary key.
In my environment, there is maintenance plan configured on one of the server and while running DBCC checkdb on a database of size around 200GB, log file usage of tempdb is increasing and causing the maintenance job to fail.
What can I do to make the maintenance job run successfully, size of the tempdb database is only 50GB and recovery model is set to simple. It cannot be increased as the mount point on which it is residing is 50GB.
If I start a long running query running on a background thread is there a way to abort the query so that it does not continue running on SQL server?
The query would be running on SQL Server 2005 from a Windows form application using the Background worker component. So the query would have been started from the background workers DoWork event using ado.net. If the user clicks an abort button in the UI I would want the query to die so that it does not continue to use sql server resources.
One of my stored procs, taking one parameter, is running about 2+ minutes. But if I run the same script in the stored proc with the same parameter hardcoded, the query only runs in a couple of seconds. The execution plans are different as well. Any reason why this could happen? TIA.
Hello Reporting Services 2005 users or Reporting Services Team, I have done everything to get pass this error but no luck. My setup is :- WIndows 2003 Standared Edition SP1 Sql Server :- Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Reporting Services starting SKU: Standard. From the Reporting Services Configuration Manager: I can see all other things configured except Encryption Keys(blue sign) Initialization(Grey sign) and Execution Acct(Yellow sign) My windows Service Identity is using : NT AuthorityNetworkService Builtin Acct :NetworkService
Web Service Identity :- ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861 and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know. I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup : Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:- w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/ w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
Hi! Please help with the following:Our disk space is limited. I set the database recovery model to"FULL", and backup transaction log every hour between business hours.But the disk is always full because the transactions log growth. Doyou think increase the frequency of transaction log backup or backuptransaction 24 hours instead of only business hours will solve theproblem?Thanks!!
I regularly get the message : application log is full. I cleared event viewer's log file but it didn't help. What is this message about? Thanks in advance,
I have a transaction log which is 1 Gb and only has about 40 Mb free. When I run DBCC loginfo I find the first active log dates back to the middle of August. Does any one have any suggestions on the best way to approach this situation. How can I query the transaction log to find out what the old transactions are? I was going to use the detach database, rename log, attach database to shrink the log but don;t want to do this incase there is active data in the log. We are doing hourly log dunps. Thanks Grant
Good morning, my SQL Server 7.0 Enterprise Manager isn't displaying any of the system databases or any of the system objects in any user databases what's the setting that I can use to change that?
I need to view tempdb because I'm getting this msge in query analyzer
Server: Msg 9002, Level 17, State 2, Line 1 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
I haven't done a transaction log backup before, and I'm not sure I want to touch any of the system db's What's my best option? Irene M.
We are running SQL 6.5 & SMS 1.2 in the same server. And we're having problem with the SQL server that error log 1105 appreared. SQL inidicated msdb and tempdb log size were full. I used dump trans with no_log but ISQL response: " This command did not return data, and it did not return any rows". Then we recovered the SMS data space available is 0 mb. I expanded the SMS database but the data space still shown 0 mb. Restart and reboot did not helped. I used DBCC Checkdb but it did not show any error. Please any advice or suggestion are appreciate!
Problem with Msdb error 1105 can not allocate space in sysbackupdetail. msdb has 1.0MB of database space available and 1.97MB of log space. I intended to expand the database but must first expand the device. the available space for the device is -703. So I can not adjust and expand. Any ideas. My hourly dumps appear to be functioning if you view them ny expanding the device but tasks show them as failing.
My Transaction log has 0% Log Space available. I have performed a dump transaction with no_log but to no effect. I have also extended the log size from 100MB to 200MB and this has not made any inmpression either after several dump database statements also. The Data Device was 500MB and I extended it to 800MB and again performed a backup. Has anyone any idea how to recover from this situation ? I can make queries on the data fine but the several backups(and Truncate log) I have made are still not creating any space for my Transaction log.
Hi! I need help! We have 98% transact log full. After run DUMP TRANSACTION WITH TRUNCATE ONLY it still doesn't purge the log. How can we resolve problem.
Hi all I found that my transaction log is beig filled up and I tried to truncate it from DB properties window and I failed. I want to know how to truncate it and how to prevent it from growing up untill it's filled Thanks Mohamed
Our transaction log filled up the hard drive on the server and we are looking for a quick and easy way to delete it. Any ideas? We can't easily back it up because it is over 10500 meg in size.
I need help fast. I have a SQL Server 6.5 SP2 database that is 5000 MB and the transaction log is 1000 MB the log is 98 % full but will not truncate. I have tried all the truncate commands (Truncate only, no_log, DBCC) but it will only trucate the log like 10 MB. Dose anyone know how to truncate this log??
Hi, I am using a cursor in my stored procedure(sql server 2000). If the table which i am using has 20000 records it works fine. If the table got around 50000 records I got the following message from the server. ---------------------------------------------------------------------------- Server: Msg 9002, Level 17, State 2, Procedure medical21_stepbystep_poso_bridging_proc, Line 215 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. Server: Msg 9002, Level 17, State 1, Procedure medical21_poso_bridging_proc, Line 299 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. ---------------------------------------------------------------------------- But I got enough space for the tempdb. Please let me if you know where I went wrong.
I have a problem with the transaction log of a database. when i truncate it and check the properties if says there are 0 MB available even though it is allocated 300 MB. this seems to be causing alot of problems. Any idea why the log will not truncate??
I am getting an error when I try to DTS data to a database that the transaction log is full. I do: backup transaction db_name with truncate_only, but I still get the error. Any ideas on how to resolve this are appreciated. Kellie
When I run my client program against a database, am getting the error
"Cannot allocate object '327634423' on tempdb..syslog full...use alterdatabase etc"
I ran dump transaction with no_log.. When I checked my database size & log size there are plenty of size. but the program didn't work. At last I increased the size of tempdb from 2mb to 20mb. Then my problem was ok. Is it advisable to increase the size of tempdb? I didn't find any documentation on this. Is there some other way to fix this problem? Thanks in advance, Suresh ////////////////////////////////
I'm still fairly new to SQL server and I've just ran into a problem when dropping some tables from my DB as my transaction log has become full. I looked at books online and it basically said to backup the log so it will also truncate the log. However I've ran out of disk space on my data drive so can't take a backup.
Is there a way to just truncate the active log to shrink the size?