Viewing 15 posts - 42,436 through 42,450 (of 49,552 total)
swathi (12/10/2008)
Gail Shaw,Server has total of 3.12 GB memory and from which sqlservr.exe is taking 1.7gb which is the maximum among all the processes that r running at that time.
Nothing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:51 am
In that case, set the database to restricted users before starting the backup. That means that only members of db_owner, db_creator and sysadmin may access the DB.
If that's not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:46 am
Snapshots?
It was existing transactional replication that I set up a couple months back to test some stuff and never dropped.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:41 am
Schadenfreude-Mei (12/10/2008)
Insert into a table. Litteraly opening a table, adding a row and whatching the log reader.
I don't know why that's not working. I did exactly that (except I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:28 am
Why do you need to prevent users accessing the DB to do a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:26 am
What do you want to see in the following cases?
StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 18:00:00
StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 07:00:00
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:25 am
swathi (12/10/2008)
At that time if we check in TaskManager, the Sqlservr.exe is taking maximum amount of memory usage.
Nothing unusual there. SQL will take as much memory as it's allowed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:23 am
What info are you looking for?
Try this:
select * from sys.symmetric_keys
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 6:31 am
asrisl (12/10/2008)
I don't have that in my list of programs, or in any menu that is on-screen when SQL Server is running.
It's not a SQL menu. Window's administrative tools....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 6:25 am
asrisl (12/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 6:07 am
Needs more quotes
CAST(S.xusertype AS INT) = CAST(C.[User_Type_Id] AS INT)
WHERE T.[Name] = ''' + @TableName + ''' AND
T.Schema_Id = 1' --@@@@ (1 = dbo.)
Square brackets denote identifiers, ie table or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 5:58 am
asrisl (12/10/2008)
How is this possible? (Is it possible without something insidious driving it?). (In these cases, SqlServer is not listed as a running Application.)
It won't be listed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 5:50 am
sunandas (12/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 5:42 am
Thread continues: http://www.sqlservercentral.com/Forums/Topic616816-1291-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 5:41 am
mohd.imtiaz (12/10/2008)
yes..
Why did you delete the post with the table and index definitions? Please post them again. I can't suggest indexes without having the table definition at the very least.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 5:40 am
Viewing 15 posts - 42,436 through 42,450 (of 49,552 total)