Forum Replies Created

Viewing 15 posts - 136 through 150 (of 611 total)

  • RE: get i/o physical read/writes for daterange

    JasonClark (1/8/2017)

    You may use this statement to check the virtual I/O file states

    SELECT * FROM sys.dm_io_virtual_file_stats (NULL, NULL);

    GO

    This shows you how many I/Os occurred, with latencies for all the files.

    It...

    January 9, 2017 at 4:51 am

    #1921327

  • RE: SQL 2016 and cloud compatibility

    Would it not simply be better to install a VM in Azure and run the database from there? Other Cloud platforms IMHO will simply add a layer of complexity...

    January 7, 2017 at 1:27 pm

    #1921250

  • RE: get i/o physical read/writes for daterange

    This sounds like a job for a server-side trace during a time that you expect the IO to occur.

    I don't think there is a way to collect this information for...

    January 7, 2017 at 1:22 pm

    #1921249

  • RE: Backup script for Availability Groups

    Hi all and sorry for not responding earlier.....

    The answer was quite simply that I didn't put the FETCH inside the BEGIN...END block.

    This is the final script:

    CREATE PROCEDURE sp_AGDB_Backup

    AS

    IF (SELECT   COUNT(*)...

    January 7, 2017 at 1:17 pm

    #1921248

  • RE: Alerts configuration

    ramyours2003 (1/5/2017)

    Can you pls help in configuring of alerts like dead lock , disk space , job failed , backup status , db offline , memory utilization , long...

    January 6, 2017 at 1:15 am

    #1921039

  • RE: Is there a matured solution to ETL excel data?

    Jeff Moden (12/26/2016)

    halifaxdal (12/26/2016)

    Thanks, still very tedious, actually adding one step here because data is eventually to be imported into SQL (or NoSQL), right?

    It'll be much less tedious to brow...

    December 31, 2016 at 10:10 am

    #1920214

  • RE: Filestream performance

    If you are in a code freeze then I can't imagine that FS in ist own right is the problem.

    Are the files held locally on the server or on a...

    December 31, 2016 at 10:05 am

    #1920213

  • RE: recommendation of tempb files

    Jeff Moden (12/31/2016)

    In the past, a lot of people have recommended multiple files for TempDB only if TempDB has a problem. And, in the past, I've ignored that advice...

    December 31, 2016 at 9:42 am

    #1920211

  • RE: recommendation of tempb files

    SQL Learner - VKG (12/31/2016)

    And this is what we do on production environment :

    1. 4 tempdb datafiles on Primary File Group with exactly same size (1024 MB) and same autogrowth...

    December 31, 2016 at 9:20 am

    #1920209

  • RE: recommendation of tempb files

    Phil Parkin (12/31/2016)

    kevaburg (12/31/2016)

    Phil Parkin (12/31/2016)

    kevaburg (12/31/2016)

    Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.

    The reason I said this is because of this statement......

    As...

    December 31, 2016 at 8:42 am

    #1920204

  • RE: recommendation of tempb files

    Phil Parkin (12/31/2016)

    kevaburg (12/31/2016)

    Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.

    The reason I said this is because of this statement......

    As a general guideline,...

    December 31, 2016 at 8:16 am

    #1920200

  • RE: Huge regression after upgrading from 2014 to 2016

    Phil Parkin (12/31/2016)

    Jeff Moden (12/31/2016)

    kevaburg (12/31/2016)

    I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server for...

    December 31, 2016 at 8:00 am

    #1920199

  • RE: SSRS 2016 Errorlog

    It sounds like someone made an illegal change in one of the CONFIG files.

    Have you got a backup you can restore?

    December 31, 2016 at 4:55 am

    #1920194

  • RE: SSRS 2016 Error

    Have you looked in the ExecutionLogs in ReportServer_TempDB?

    They should provide some insight and can be queried easily enough.

    December 31, 2016 at 4:53 am

    #1920193

  • RE: recommendation of tempb files

    Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.

    Experience that I have gathered has shown me that an initial Installation with 5 datafiles with 1GB...

    December 31, 2016 at 4:51 am

    #1920192

Viewing 15 posts - 136 through 150 (of 611 total)