Viewing 15 posts - 226 through 240 (of 310 total)
In addition to what Grant has said, you may find it useful to install the Performance Dashboard Reports.
These are great for not only identifying your highest WAIT types but also...
March 16, 2009 at 9:43 am
1.2GB is quite a small amount of memory.
How much memory do you have on your server in total?
Is SQL Server the only process running on your server?
How big is your...
March 16, 2009 at 8:12 am
Did I miss something?
How did you solve your problem?
Cheers,
March 16, 2009 at 8:05 am
SQL Frenzy (3/15/2009)
Does the earlier configuration wud hv any effect on the web application running on sql server 2005.
If by this statement you mean that you were running a web...
March 16, 2009 at 8:01 am
Hi there,
Here is a detailed article including examples on working with SQL Server endpoints.
http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/[/url]
Cheers,
March 14, 2009 at 3:40 am
Hi,
What version of the Windows Operating System are you running?
Either way, this article will point you in the right direction to all the information you need. The memory section will...
March 14, 2009 at 3:19 am
Although a bit of a punt, I would suggest intalling the latest SQL Server 2005 Service Pack. I have had issues with the SQL Server Management Stuid (SSMS) GUI on...
March 13, 2009 at 5:02 am
karthikeyan (3/13/2009)
I ran your command and it does not showed the filegroup.
Ah, perhaps you are not using SQL Server 2005.
Example execution on my platform, although somewhat difficult to read.
sp_helpdb 'SANDBOX'
namedb_sizeownerdbidcreatedstatuscompatibility_level
SANDBOX...
March 13, 2009 at 3:17 am
karthikeyan (3/13/2009)
I have removed the file from the db after I made it as empty.
I can not remove the filegroup from db.
I got the below error when I try to...
March 13, 2009 at 2:50 am
Hi there,
Just to qualify your issue a little further, are you looking at the properties of a database by right-clicking a given DB in SQL Server Management Studio?
Also, it may...
March 13, 2009 at 2:34 am
Hi,
If you are looking at or investigating the performance of your server overall, looking for poorest performing queries etc. then you may wish to look at using the SQL Server...
March 12, 2009 at 5:57 am
Hi,
If you right click the Server node, in the Object Explorer window of SQL Server Management Studio, the information regarding the currently installed version of SQL Server 2005 will be...
March 12, 2009 at 5:49 am
Hi karthikeyan,
In order for us to achieve a better understanding of your environment/configuration, would you be so kind as to post the details for all files and filegroups that makeup...
March 11, 2009 at 6:30 am
Viewing 15 posts - 226 through 240 (of 310 total)