Viewing 15 posts - 301 through 315 (of 492 total)
Did you restrict the SQL Server or not with Max Memory parameter if not then it can use more memory , 100 GB RAM is too high, what is the...
May 6, 2011 at 9:51 am
Make a resource pool with the help of Resource Governor for the specific user and then login with it and then update the statistics
May 6, 2011 at 9:45 am
Q1 - at the time of installing SQL in cluster environment it is not showing option to select seprate partition for data (MDF) and log (LOG).
Q4 - disk dependancies -...
May 6, 2011 at 9:29 am
Backup file and Restore path is Same ?
otherwise check Activity Monitor on SSMS and query with sys.sysprocesses to check the wait resource at the time of Restore
May 6, 2011 at 9:14 am
There are multiple disk use to make a single partition or drive with the help of RAID levels,Cluster is use for High Availability if 1 node fail then second node...
May 6, 2011 at 9:10 am
I didnt use this Whatsup Gold Network Management Tool but it have a application monitoring module,I can say if you disabled the service this tool check the service after some...
May 6, 2011 at 9:01 am
Raid 10 is better than Raid 5
Raid 10 is specially use for Tempdb,Log Files and Indexes Files,If you have enough space on these disk then go to RAID 10 other...
May 6, 2011 at 8:54 am
yes you can install but one is default instance and other must be named instance
May 6, 2011 at 8:42 am
Latest APR 29,2011 Cummulative Update 7 for SQL Server 2008 R2 is available now
May 6, 2011 at 8:38 am
you can install multiple clients of different version
May 6, 2011 at 8:34 am
Madness.
Repairing master (even a copied master) is unlikely to work. Most of master are system objects (all of master should be) and if there's something wrong severe enough to prevent...
May 6, 2011 at 8:31 am
Can you connect on the same Server with SSMS ?
SQL Server 2008 or SQL Server 2008 R2,client and server both are ?
If client is SQL Server 2008 and Server is...
May 6, 2011 at 8:19 am
Which Version of OS and SQL Server you are using and Total Memory and allocated memory for SQL Server
Have you applied update Service Packs and Cummulative Updates,if not then apply...
May 6, 2011 at 5:05 am
SELECT ST.TEXT,SP.* FROM SYS.SYSPROCESSES SP
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST
WHERE SPID > 55
ORDER BY SP.CPU DESC
this query provide you information about the bottleneck
May 6, 2011 at 4:56 am
you should use local server to remote server login mapping in linked server properties as shown in the figure
May 6, 2011 at 4:54 am
Viewing 15 posts - 301 through 315 (of 492 total)