Can you please let me know where I can set the MAX IDLE TIME for the SQL SERVER CONNECTION.
IS this the value set for the KEEp Alive propoerty in the sql server configuration Manager.
View Complete Post
I have a thin C# application with SQL server 2005 standard Edition . Database size is 15GB . The server has 16 GB RAM and 2.6 Ghz Xeon processor, with 4 cores. Application has lot of stored procedures performs some calculations and transfer the
data from one database named a to second database named b. Users can also get the reports from report database .
1: The application is much slow when it perform analysis (some calculations )
2: CPU usage goes to 100% and sometimes application crashes with this message.
timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I have to optimize the application . I have found some duplicate non cluster indexes.
for example if i have primary key PK index (clustered) on the fields 1, 2 ,3
there is another index which is non clustered on the same fields (1,2,3)
there are around 10 to 15 tables with the same duplicate non clustered indexes.
I have few Questions :
How can i configure the sql server 2005 to perform parallel executions of queries to utilize the all cores of CPU.
2: How can i know which query or store procedure is taking too much execution time and getting system resources.
3: How to know which index is fragmented&n
How i can set idle timeout in SQL server 2005? In case of Oracle we can set this using profile.
But we don't know how to set in SQL server 2005/
Response from experts would highly help us to proceed our testing.
Thanks in Advance
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
I have built a custom SSIS component for connecting to SQL Reporting Services in SSIS - including a custom data source and custom connection.
It works fine using 32bit DTEXEC and dtsdebughost, but I cannot get it to load in a 64bit environment.
Initialy I was compiling the dlls as MSIL (target=any), then I recompiled specifically targetting x64 (copying the dlls to the 64bit location and deploying to the GAC), just to see whether the problem was because of using an MSIL binary.
The 32bit version works as expected - are there any additional registration steps required for a 64bit Connection manager beyond copying to the /connections directory and installing into the GAC?
The output from DTSEXEC:
c:\Program Files\Microsoft SQL Server\90\DTS\Binn>DTExec.exe /f "e:\temp\SSISCus
tomADComponent\TestSSISSolution\Integration Services Project1\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:07:30 p.m.
Error: 2010-09-22 12:07:43.89
Description: The connection type "SSRS" specified for connection manager "SQL
Server Reporting Services" is not recognized as a valid
I am using SharePoint 2007 and trying to set up some KPIs in Executive Dashboard.
I have an ODC uploaded to my document library which has been connected to analysis
services cube which also has some kpi's. When i use the ODC file to connect to analysis
services to retrieve the KPI they don't seem to appear under ALL KPI'S and i also get an
This data connection does not use encryption for the communication with the SQL Server
2005 Analysis Services server. It is recommended to enable encryption for the SQL Server
2005 Analysis Services server to help prevent unauthorized users from viewing this information.
The connection either timed out or was lost.
The same works connection file works in Excel.
i've installed SQL server 2005 express and Visual web developper 2005 express.
when i whant to create a database in VWD the following error occures:
connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251
i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays.
When you first fire up Sql Server 2005 Management Studio, there is a drop down connection box with previously connected to servers. Is there a way to increase that number of recently used servers? I have about 15 that I constantly connect to
and the dropdown is so much easier. Looking for aproperties file or reg edit or something.
sql version: Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86) Dec 17 2008 15:19:45 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
OS: Win XP SP 3
I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.
Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).
Any idea plz
i am working on VS2005 and ssrs 2005
I have a VB6 app that gets data from several devices and has to store it in a SQL server 2005 database.
It may have to store small amounts of data (a few KB at most) somewhere between 5 and 500 times per day.
My app only sends data to DB, doesn't read anything.
a) the app opens a connection to DB at startup and closes it at exit, or
b) when data arrives, the app opens a connection, sends data, then closes the connection